M marcs Active Member Joined May 3, 2005 Messages 420 Dec 13, 2005 #1 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
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
M marcs Active Member Joined May 3, 2005 Messages 420 Dec 13, 2005 #2 Ah, think I've found it! Code: Set LastRND = Range("M" & Rows.Count).End(xlUp).Offset(-2, 0)