Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping formatting multiple sheets
I'm sure I can accomplish this with the macro recorder, but it would
generate a ton of unneccesary code. I import a text file into Excel 2003 then using Debra's (Contexture's) copy to different sheets macro I end up with 34 sheets (including the original, but I'd like all sheet in the workbook formatted no matter the number, which could possibly change) I'd like to 1. Header row A1:S1 row height 15 font red bold, background yellow 2. Remainder or rows height 78 3. Then insert a column not sure of syntax, manually click column C then insert column Thanks for any and all help Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Header on Multiple Sheets without Changing Other Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting using multiple sheets | Excel Worksheet Functions | |||
Why Not Conditional Formatting For Multiple Sheets? | New Users to Excel | |||
How do I copy print formatting to multiple sheets in a workbook? | Excel Discussion (Misc queries) | |||
Looping through Sheets | Excel Programming |