delete rows w/o hardcoding numbers
- From: "Dave B" <david.barbetta@xxxxxxxxx>
- Date: 18 Nov 2005 10:25:05 -0800
I'd like to delete a group of rows. Normally I would do:
Rows("12:45").Delete Shift:=xlUp
But the row numbers are stored in variables. I can't do (causes an
error):
Rows("intBeginDelete:intEndDelete").Delete Shift:=xlUp
I can do it using a For...Next loop, deleting the rows one at a time,
but I'm working with lots of row groups & files and that makes
execution slow. Is there an easier/faster way to do this?
.
- Follow-Ups:
- Re: delete rows w/o hardcoding numbers
- From: Dave Peterson
- Re: delete rows w/o hardcoding numbers
- Prev by Date: Re: Masking an input box?
- Next by Date: Re: Removing Data
- Previous by thread: opening & copying to a workbook
- Next by thread: Re: delete rows w/o hardcoding numbers
- Index(es):
Relevant Pages
|