Deleting Rows using VBA

[SystemHack]

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.

[Arvi Laanemets]

Hi

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

(the worksheet mustn't be activated)

--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"SystemHack" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Bob Phillips]

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

--

HTH

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


"SystemHack" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Tom Ogilvy]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>