hiding rows based on a value in a column

[tinkerbelle]

Hello everyone,

I have a spreadsheet with data in the range D16:G1500

Please how would I write a macro that looks at the value in column D in reach row of the range and if the value is blank "" then it hides the row?
I dont want to use a worksheet change as the data is arranged in a pivot-table and I would like to make selections from the pivot table and then set the macro to hide the rows without data in column D.

Thank you very much, Lucy

[Marc L]

Hi,

why not just using an easy filter so without the need of any code ?

[Pepe Le Mokko]

@tinkerbelle

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[tinkerbelle]

Hi I am on Excel 2010. I will update my profile.

[tinkerbelle]

Help appreciated, thanks

[nigelog]

Please Login or Register  to view this content.

[tinkerbelle]

Hi, thanks so much, this really helped.