Deleting Rows using VBA
 

All I have found as far as tutorials is how to delete empty rows by
using a calculation to determine if the row is empty. Is there any way
to simply say, "delete row 3" or something of that nature. Based on
user input I will know the exact row number to delete and this would
help alot. thanks.


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=400351

Deleting Rows using VBA
 

Hi

....
Worksheets("SheetName").Rows(RowNumber1 & ":" & RowNumber2).Delete
Shift:=xlUp
....

(the worksheet mustn't be activated)

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"SystemHack" wrote
in message ...

All I have found as far as tutorials is how to delete empty rows by
using a calculation to determine if the row is empty. Is there any way
to simply say, "delete row 3" or something of that nature. Based on
user input I will know the exact row number to delete and this would
help alot. thanks.


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile:
http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=400351

Deleting Rows using VBA
 

ans = InputBox("Delete which row?")
Rows(ans).Delete

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SystemHack" wrote
in message ...

All I have found as far as tutorials is how to delete empty rows by
using a calculation to determine if the row is empty. Is there any way
to simply say, "delete row 3" or something of that nature. Based on
user input I will know the exact row number to delete and this would
help alot. thanks.


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile:
http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=400351

Deleting Rows using VBA
 

ans = InputBox("Delete which row?")
On Error Resume next
set rng = Rows(ans)
On errror goto 0
if not rng is nothing then
rng.Delete
end if

--
Regards,
Tom Ogilvy


"SystemHack" wrote
in message ...

All I have found as far as tutorials is how to delete empty rows by
using a calculation to determine if the row is empty. Is there any way
to simply say, "delete row 3" or something of that nature. Based on
user input I will know the exact row number to delete and this would
help alot. thanks.


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile:
http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=400351