Excel Macro - Go to next unused row 2

[harrisharris]

I have data stored in individual rows with loads of conditional formatting . I am trying to write a macro that will take me to the first cell of the next empty row. "End(xlDown).Select" takes me to the last used cell, but how do I go down one more? Would appreciate some help on this. Thanks

 

[xlbo]

mRow = Range("A1&quot.end(xldown).row + 1
range("A" & mRow).select

I tend to use xlup tho

mRow = range("A65536&quot.end(xlup).row + 1
range("A" & mRow).select

HTH Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes

 

[Draig]

Alternatively, once you're at the last used cell, use the Offset() method to move down one row:
Selection.Offset(1,0).Select

Barborne
Worcester
UK

 

[Loomah]

OR combine the above into one line

Range("a1").End(xlDown).Offset(1, 0).Select

Take heed of xlbo's comments re using xlUp though. This code will slect the next blank row, and is not much use if you have gaps in your data.

Happy Fiday
;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[harrisharris]

Many thanks Geoff for your quick response - I decided to go for barborne and Loomah's solutions as they appeared easier. Thanks barborne and Loomah, it worked like a dream.

Laurence
Tewkesbury