Select blank cells used range rows and columns

[emina002]

Hi All,

Hope you can help me figure out how can I select used range rows and columns and paste the desired formula. Ok my problem selecting the blank cells(count of rows and columns not fixed)

On my sample workbook I attach here, rows occupied is until row 42 and columns on row 2(Col H) I just want to select B3 to H3 down to row 42(but then I just want to clear that used range of column and rows is not fix). Your help on what code should I used will be appreciate.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[emina002]

Hi @John Davis,this is what I am looking for. I copied already on my actual file and adjusted the code. On my actual file,the Activities column start on Col D. I just cant get it right on how to adjust the used range rows.

[JOHN H. DAVIS]

Can you attach a sample showing your actual file layout?

[emina002]

Hi @John Davis,

Here is the actual file.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[emina002]

Yes! Thank you so much @John Davis

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.