Thu 27 Oct 2011, 10:17Delegate Clare said...
Clare has attended:
Excel Intermediate course
Excel Intermediate course
Hidden Rows
Is there any way to view only the hidden rows on your spreadsheet?
Mon 31 Oct 2011, 13:14Delegate Barry said...
RE: Hidden Rows
Hi Clare, how many rows are we talking about all together including the hidden ones please?
Baz
Mon 31 Oct 2011, 14:56Delegate Clare said...
RE: Hidden Rows
Hi Baz,
Its 155, including the hidden ones.
Regards
Wed 2 Nov 2011, 13:53Trainer Paul said...
RE: Hidden Rows
Hi,
I have looked through all of the normal settings in Excel and I cannot find a way of doing that. You will be able to write some VBA code that can do this, but not the way you are looking at just seeing the hidden sheets.
Thanks
Paul
Wed 2 Nov 2011, 14:13Delegate Clare said...
RE: Hidden Rows
Ok. Thanks very much for your help.
Wed 2 Nov 2011, 14:40Trainer Paul said...
RE: Hidden Rows
I will double check with another VBA trainer and let you know if he knows of a way.
Thanks
paul
