vba code to clears cells and hide rows

[Zimmerman]

I'm looking for some help on how to clear cells and hide rows when I hit a command button. These cells do not have any formulas in them. I need to clear the following cells
C123:H123
C125:H125
B109
F109
G109
B94
F94
G94
B79
F79
G79
B64
F64
G64
B49
F49
G49
B34
F34
G34
B19
F19
G19
B4
F4
G4
Then after it clears those cells I would like it to hide rows 6 - 119

[LukeGilfoyle]

I'm looking for some help on how to clear cells and hide rows when I hit a command button. These cells do not have any formulas in them. I need to clear the following cells
C123:H123
C125:H125
B109
F109
G109
B94
F94
G94
B79
F79
G79
B64
F64
G64
B49
F49
G49
B34
F34
G34
B19
F19
G19
B4
F4
G4
Then after it clears those cells I would like it to hide rows 6 - 119

Record a macro yourself by going to the 'View' Tab in the ribbon and creating a macro. Once you give it a name, press record.

When it's recording, click the cells you want to clear and press 'delete' -- then select the rows you want to hide and 'right click' and press 'hide'.

stop recording the macro and then you will have the code.

Hope this helps,

regards,

[Zimmerman]

Yeah I just thought of that myself. Did what exactly what you said and it works fine. Thanks

[LukeGilfoyle]

Yeah I just thought of that myself. Did what exactly what you said and it works fine. Thanks

Great, please leave reputation for me and mark thread as solved.