Go to first blank cell below current region

[VBAProIWish]

Hello All,

Is there a way through code to go to the first blank cell below the current region?


Thanks

 

[VoG]

Hi. Try

ActiveCell.CurrentRegion.End(xlDown).Offset(1).Select

 

[VBAProIWish]

VoG,

Is there a way I can record moving five cells to the right.

I tried using the macro recorder but after pressing "stop" and viewing the macro, it recorded nothing.

I need the cell selection to end up in column F of that row.

BTW-Your macro worked perfect in getting me to the first blank row below the current region, thanks much for that. Now I need to move the selection 5 cells to the right.


Thanks again

 

[VoG]

Try

 ActiveCell.CurrentRegion.End(xlDown).Offset(1, 5).Select

 

[VBAProIWish]

Yes Yes Yes!

That's it, thank you much