Hi all,
I'm having an issue with hiding columns. I have a worksheet with a statement summary at the top and on row 20 filters to select customer invoices.
Now, i set a macro to hide rows 1-19 and certain columns - say B, D, & F. Hiding manually by highlightling and selecting hide works, but when i replay back the macro it hides columns A-C, for example. I have no idea why it does this and i experimented with using column widths at 0 instead, but with the same result.
I would post the code, but i don't have it right now (it's v.simple). In the meantime if anyone has come across this problem before and knows how to solve it i would be very very happy.
Thanks as always,
Chris
Bookmarks