Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does macro change print range?
I am using Excel 2002 SP3 and have a spreadsheet with some columns I do not
want to print on the printout for my customers. If I manually select the columns and hide them and then use Print all is fine ... but when I record what I do in a macro the printout omits 4 columns prior to the 3 that I hide and prints out a meaningless report. I have looked at the code and it appears to hide the correct columns. The only other thing I can think of is that I am using the 'Scale to fit one page wide' to make the report fit ... the printout from the macro looks like it could be at 100% scaling. Help! what (if anything) am I doing wrong? -- Rob Harrison |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print range is gray and i cannot change | Excel Worksheet Functions | |||
print out specified range in macro | Excel Discussion (Misc queries) | |||
Print range macro | Excel Discussion (Misc queries) | |||
Print Range Macro | Excel Programming | |||
Macro print range | Excel Programming |