DELETE ENTIRE ROW
 

HI,

If I have "Set" 2 cells, toprng and botrng, how can I delete the rows between
them

Regards

FIRSTROUNDKO

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1

DELETE ENTIRE ROW
 

Pls don't type in all caps

Sub deletebetweennamedrows()
fr = 3
lr = 7
Rows(fr & ":" & lr).Delete
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FIRSTROUNDKO via OfficeKB.com" <u15639@uwe wrote in message
news:890c48048b384@uwe...
HI,

If I have "Set" 2 cells, toprng and botrng, how can I delete the rows
between
them

Regards

FIRSTROUNDKO

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1

DELETE ENTIRE ROW
 

with toprng.parent
.range(toprng,botrng).entirerow.delete
end with

"FIRSTROUNDKO via OfficeKB.com" wrote:

HI,

If I have "Set" 2 cells, toprng and botrng, how can I delete the rows between
them

Regards

FIRSTROUNDKO

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200808/1

--

Dave Peterson