Re: Excel 2003 - Macro for Deleting Rows
- From: "Solon" <SolonAquila@xxxxxxxxxxxxxxx>
- Date: Sat, 8 Dec 2007 10:19:06 -0500
OHHHHH.. didn't know that little tidbit.. much thanks!
Solon
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:d6rjl3l9g7o5b4n6pi4h5p2dpvk6kabtoi@xxxxxxxxxx
CTRL + Down goes to cell above first empty cell in the column, not
necessarily
to last used row.
See other responses for getting true last row and giving it a numbered
value.
Gord Dibben MS Excel MVP
On Fri, 7 Dec 2007 19:05:42 -0500, "Solon" <SolonAquila@xxxxxxxxxxxxxxx>
wrote:
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,
.
- References:
- Excel 2003 - Macro for Deleting Rows
- From: Solon
- Re: Excel 2003 - Macro for Deleting Rows
- From: Gord Dibben
- Excel 2003 - Macro for Deleting Rows
- Prev by Date: Workbook Sharing
- Next by Date: Re: Excel 2003 - Macro for Deleting Rows
- Previous by thread: Re: Excel 2003 - Macro for Deleting Rows
- Next by thread: Re: Excel 2003 - Macro for Deleting Rows
- Index(es):
Relevant Pages
|