the cell above the bottom cell

marcs

Active Member
Joined
May 3, 2005
Messages
420
I can't find how you say "the cell above the bottom cell"

I'm using
Code:
Set LastRND = Range("M" & Rows.Count).End(xlUp)

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

All help appreciated
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

marcs

Active Member
Joined
May 3, 2005
Messages
420
Ah, think I've found it!

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

Watch MrExcel Video

Forum statistics

Threads
1,118,676
Messages
5,573,603
Members
412,538
Latest member
mrjack
Top