You should always post YOUR macro for comment and suggestion.s

lr=cells(rows.count,activecell.column).end(xldown) .row

However, you need not and should not select it. Post your macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Solon" wrote in message
...
Greetings,
Still using Excel 2003. Now that I have a macro that will delete rows, AND
do it from the bottom up, I've got another question.

The guy who gave me the macro said he'd never considered doing a
"Ctrl+Down" to simply go to the last used row, then do his search from
there, but figured that there HAS to be a way to get Excel to set that row
number as a variable, then have the macro use that number as it's starting
point.

But neither of us can figure out how to get the macro to 'get cell row
number' or whatever could then be used as the starting point.

We can tell the macro to

Selection.End(xlDown).Select

But then how do we tell it to say "Oh, I've gone down this many rows" and
set that as the 'rowEnd' variable.

Any ideas?

Solon