Finding empty rows

O

ogopogo5

How can I write a sub-routine that will look for an empty row. I.E. Rows
B2 to B7 have already numbers or texts in these cells. It will check if
the cells are empty or not. If a cell is used it skip down to next cell
and until it finds an empty cell. In this case the empty cell will be
B8.



*** Sent via Developersdex http://www.developersdex.com ***
 
S

Stefi

Try this:
Range("B" & Range("B" & Rows.Count).End(xlUp).Row + 1).Select

Regards,
Stefi

„ogopogo5†ezt írta:
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„ogopogo5†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a empty / blank column 2
Finding a used / filled rows 4
Finding empty rows 1
Search for empty cells and move cells next to 10
REARRANGEMENT OF CELL VALUES !! 4
Finding a used / filled column 2
Find an empty cell across columns 2
How to do this with macro? 2

Top