Find first blank cell in first column of known range, select and delete from that point

Hello Everyone,

This should be an easy one, but not for me Please refer to the attached screenshot for more info.

Find Blank.PNG

I have multiple tables like the one in the picture and have to duplicate this code for different known ranges.

Any help would be great!

Thanks for the reply nathansav!

I changed your code slighty to this:

Please Login or Register  to view this content.

I Don't want the blank cells to be removed, just clear the contents. I also need it to select from the blank cell at A13 to D18 and not just delete the A column data. This selection won't be the same in all cases, but the destination cell in the selection would always be known.

Ex. select from first blank cell in the range A8:A18, blank cell ="x"

Range ("X:D18").Select
Selection.ClearContents

Does anybody have any ideas on how to do this?

sorry to keep asking, but I really need help with this problem. Any ideas?

sorry, let me try and explain better. If you open the image I uploaded on my first post above, I need the code to find the first blank cell in the A column starting from A8 (red box), then select from that first blank cell to D18 and clearcontents (anything in the green box). So I want the formulas in the green box cleared, not he blank cells, but I would assume it would just be easier to select the whole range.

Making any sense?

Thanks for the reply nathan, in excel I get a "type mismatch" error on

Please Login or Register  to view this content.

Any thoughts?

No errors this time. Seems to run, but nothing happens (ie. nothing is cleared).