Hi,
How do I write a macro to delete the content of a column? Please let me know. THanks.
Hi,
How do I write a macro to delete the content of a column? Please let me know. THanks.
Record a macro as you select and clear a column.
You will end up with a macro similar to this
Sub Macro1()
Columns("D:D").Select
Selection.ClearContents
End Sub
The abave macro can be changed to
Sub Macro1()
Columns("D:D").ClearContents
End Sub
Hi Owl,
Try:
Columns(1).ClearContents '(Retain formatting)
or
Columns(1).Clear '(Clear contents and formatting)
---
Regards,
Norman
"owl527" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> How do I write a macro to delete the content of a column? Please let me
> know. THanks.
>
>
> --
> owl527
> ------------------------------------------------------------------------
> owl527's Profile:
> http://www.excelforum.com/member.php...o&userid=20916
> View this thread: http://www.excelforum.com/showthread...hreadid=546424
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks