(i was probably trying too hard to make that happen before). ![]() On the finished cell and dragged or drug downward and it filled in the rest of them just fine. ![]() after doing just 1 cell, moving the mouse around to the lower right corner it turned into a plus sign, i clicked instead of me typing in the cell, a1, i clicked on the cell and it highlighted and did whats expected. so the module as written, when trying to use formatmac(a1) it says syntax error, but formatmac(1122334455) produces 11:22:33:44:55 If you work with formulas in Excel on Mac often, these shortcuts can help you do things faster. Ok, got it to work, i added it again as a module as this time it saw it. Show the Format Cells dialog box: Command + 1 Show the Modify Cell Style dialog box: Command + Shift + L Add a border to selected cells: Command + Option + 0 (zero) Remove outline borders: Command + Option + Hyphen (-) Working with formulas. so it looks like Excel at least found it, but in the worksheet it will not let me use it. Avec? when powering on the computer today and opening up that file, it had a warning message that a macro is there from a source that cannotīe verified, enable macros anyway? yes. If i try to enter a function =FormatMAC(a1) then hit enter, it, the cell, says "Name?" as if it cannot find it at all. so i copied/pasted the function, and saved it, but in the spreadsheet But in Excel 2007 there is NOTHING in any of the menus there that indicates this, i had to find out from reading articles.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |