End Range on next blank cell

[n0v1c3]

I would like to know how to get this macro to end it's range when it comes across a blank cell.

This is the code I have so far:

Please Login or Register  to view this content.

What do I need to replace the ???? with so that it doesn't keep inserting rows beneath cells that have empty rows beneath them already?

Thanks in advance.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[pike]

Hi n0v1c3
Can you please go back to your first post and edit and add the code tags
It would be easier to help if we knew what you are doing

Please Login or Register  to view this content.

[n0v1c3]

I've tried

Please Login or Register  to view this content.

but it keeps inserting rows under the new additions instead of finding the last blank cell as the end of the range.

[pike]

maybe..

Please Login or Register  to view this content.

[pike]

maybe..

Please Login or Register  to view this content.