Automatically hide row if cell equals the same as cell above

[tool_fairy]

Hiya,

I'm trying to find a macro to automatically hide a row if the cell A equals the same as the cell above, and unhide if this changes.

For example, if A4 equals A3 then hide row 3. The cells in row A are automatically populated so if this the cell changed then it would need to unhide but this is fine to only refresh when opening the tab. There is no particular range though it isn't going to go any higher than row 100.

I hope that makes sense.

Thank you in advance.

Tim

[DarkF1ame]

Hello Tim,

Give this a shot, in my brief trial on a test worksheet it seemed to do what you are looking for. This only triggers when the tab is activated though, and it is only comparing values in column A. Hope it helps:

Please Login or Register  to view this content.

[davesexcel]

Probably a loop will be simplest

Please Login or Register  to view this content.

[tool_fairy]

They both seem to do the job. Not quite sure what the differentiates the two methods to be honest but they both seem to work. Cheers both of you.