Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A recorded Macro to hide certain selected columns hides non selec.
I have recorded a macro to hide certain columns (E, F, G, L, N, O, P, Q,
S:AA) in a spreadsheet which when I do it manually works fine. When I run the the macro it hides everything from B to AA. Why? How can I fix this. I have tried just hiding one column with the macro and it still hides them all. The Spreadsheet has merged columns, but that does not seem to be a problem when done manually. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A recorded Macro to hide certain selected columns hides non selec.
with worksheets("sheet1")
.range("e:g,l:l,n:q,s:aa").entirecolumn.hidden = true end with If this doesn't help, you may want to post your code. Mlmotter wrote: I have recorded a macro to hide certain columns (E, F, G, L, N, O, P, Q, S:AA) in a spreadsheet which when I do it manually works fine. When I run the the macro it hides everything from B to AA. Why? How can I fix this. I have tried just hiding one column with the macro and it still hides them all. The Spreadsheet has merged columns, but that does not seem to be a problem when done manually. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A recorded Macro to hide certain selected columns hides non selec.
If you post the code it might help.
-- HTH RP (remove nothere from the email address if mailing direct) "Mlmotter" wrote in message ... I have recorded a macro to hide certain columns (E, F, G, L, N, O, P, Q, S:AA) in a spreadsheet which when I do it manually works fine. When I run the the macro it hides everything from B to AA. Why? How can I fix this. I have tried just hiding one column with the macro and it still hides them all. The Spreadsheet has merged columns, but that does not seem to be a problem when done manually. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a quick way to show selected columns (not using hide) | Excel Discussion (Misc queries) | |||
code to hide hides too much | Excel Discussion (Misc queries) | |||
When i hide columns it hides whole sheet | Excel Discussion (Misc queries) | |||
Button hides unhides columns, how? | Excel Discussion (Misc queries) | |||
macro - hides everything and not just certain columns as recorded | Excel Programming |