the cell above the bottom cell

[marcs]

I can't find how you say "the cell above the bottom cell"

I'm using

Set LastRND = Range("M" & Rows.Count).End(xlUp)

and I want to specify the one above the bottom one.

All help appreciated

 

[marcs]

Ah, think I've found it!

Set LastRND = Range("M" & Rows.Count).End(xlUp).Offset(-2, 0)