delete rows w/o hardcoding numbers



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?

.



Relevant Pages

  • Re: all my email vanished -- again
    ... be fetching and then deleting all mail? ... Maybe a long shot. ... Prev by Date: ...
    (Debian-User)
  • My Recent Documents folder
    ... high-lighting the files on right-side of screen and then deleting? ... there another place (outside of Windows Explorer) where we can click on a Tab ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • Re: deleting old operating system files
    ... roll back your OS to 98 after deleting the old 98 files. ... >i now have windows xp installed - to get more space on my disk can i delete ... Prev by Date: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: macro to alter worksheet code
    ... Deleting A Procedure From A Module ... Regards, ... Shah Shailesh ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: yellow button
    ... Sky+ owners use it all the time for setting recordings and deleting them. ... Prev by Date: ...
    (uk.media.tv.sky)