Deleting nth row or column

[tarunpathria]

How can we delete nth row or column, or data in them ; without actually going to the cell & deleting it.

[Bob Phillips]

VBA?

Rows(n).Delete

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"tarunpathria" <[email protected]>
wrote in message
news:[email protected]...
>
> How can we delete nth row or column, or data in them ; without actually
> going to the cell & deleting it.
>
>
> --
> tarunpathria
> ------------------------------------------------------------------------
> tarunpathria's Profile:
http://www.excelforum.com/member.php...o&userid=31567
> View this thread: http://www.excelforum.com/showthread...hreadid=512614
>