Hide a row problem

[amne26]

Hello everyone ...
In my Excel file I have a list of actions to be carried out on a project. At the G column, I must indicate if the action is ongoing, completed or not yet started.

How to hide a line when I indicated in column G that the action is Completed

Thank you

[stanleydgromjr]

amne26,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Press and hold down the 'ALT' key, and press the 'F11' key.

Insert a Module in your VBAProject, Microsoft Excel Objects

Copy the below code, and paste it into the Module1.

Please Login or Register  to view this content.

Then run the "HideG_RowIfCompleted" macro.


Have a great day,
Stan

[SOS]

Hi stan,

I can see that the code works but wonder can you tell me when you Dim the variables as LR& and LoopCtr&, does the ampersand have any specific effect?

Just interested, that's all

Regards

Seamus

[shg]

It's the type declaration character for a Long.