If someone has a better way of doing this please let me know. This is really not ideal and a HUGE bug in the Excel system but at least now I can move pass it. Sometimes it takes a few "undo's" and doing it again before I can change the colour of the selected area or cells. In 2010, when you press the CTRL button and click on an entry in the listbox, the whole listbox gets selected. Then I undo it and then go back to format cell and and click through it again and say OK. Andreas Killer Volunteer Moderator Article Author Replied on JReport abuse receive a Visual Basic Error 'Run-time error '1004': Font size must be between 1 and 409 points.' My college runs the add-in fine using Excel 2003. Excel Font Size Must Be Between 1 And 409 Trial And Error I have attached sample data, i need someone to help me convert the left side to how the data looks on the right. IF you select the size it changes all the font to that one size which has to be undone. I have found a way which is very difficult and frustrating but you select Format Cell - Font.Ĭlicking through with the tab button - Font - Font Style - Size (as there is no size selected due to different sizes). The only easy way is to change the font size of all the cells to the same size, which is not convenient at all as sometimes the font has different font sizes and it wants to have one font size. Whenever I try to change the colour of the border of cells or an area in Mac Excel 2011 i get an error: "Font size must between 1 and 409" and cannot change the colour of the border.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |