| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array to copy formats as well...
HI!
You've helped out by showing me how to use array to copy 2 sheets to a new file and name that new file... the next problem I need help with is I need to copy the formats as well... and not the links to the new file... (Actually all I really need to do is format Column "A" to 0000) I remember seeing info on something like this but I can't seem to find it... I can do the copy formats on a normal copy/paste but it seems to lose something in the translation when I try to use the same approach with this array part of my macro... Or is there a way to format column "A" before naming and saving the new workbook? sorry to be such a pain... but 35 restaurants will be pretty happy if I ever get this project completed... Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to copy formats | Excel Discussion (Misc queries) | |||
| Copy all formats and objects | Excel Discussion (Misc queries) | |||
| copy formats vlookup | Excel Worksheet Functions | |||
| What's the best way to add a row and copy formulas and formats? | Excel Discussion (Misc queries) | |||
| Copy worksheets and formats | Excel Discussion (Misc queries) | |||
Threaded Mode
