Select (go to) next blank cell in a column VBA code?

[RBrite]

Help please!

I am trying to write a code to loop from and to the next blank cell in a column, this isn't working!

NextFree = Range("E:E" & Rows.Count).Cells.SpecialCells(xlCellTypeBlanks).Row
Range("E" & NextFree).Select

any ideas please - I really don't know what I'm doing ?

 

[Joe4]

Welcome to the Board!

Can you explain in a little more detail?
Are you trying to search column E for the first blank cell it comes to (it could be in the middle of your data), or the find the last cell in that column with data, and then select the cell below that?

 

[RBrite]

Hi Joe, thank you!

I have recorded a macro to populate a worksheet across columns A-M (from a data collation 'template' in another worksheet). I need to specify the starting point of this macro to be in the next empty cell in column E?

 

[Joe4]

You can find the last populated row in column E like this:

lastrow = Cells(Rows.Count,"E").End(xlUp).Row

So then you can select the next available cell in column E like this"

Cells(lastrow + 1,"E").Select

Is that what you need?

 

[TheSpeed]

You can find the last populated row in column E like this:

lastrow = Cells(Rows.Count,"E").End(xlUp).Row

So then you can select the next available cell in column E like this"

Cells(lastrow + 1,"E").Select

Is that what you need?

Well, I don't know, if that's what RBrite needed, but You certainly helped me, so thank You a lot!!