Excel VBA to hide Rows of Command Buttons that have no data
Posted on 2006-06-14
I am using Excel VBA
I have a command button that you click to process, it calculates and puts data in the Range of A28:Q57 depending of the scenarios. It may put data into A28:Q40, etc.
In column G28:G57 I have command buttons all the way down. I want the rows that have no data in them, but have the command button, to hide the rows.
I start with this and not sure where to go from here
With Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
Any help would be appreciated.