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

Hi Owl,

Try:

Columns(1).ClearContents '(Retain formatting)

or

Columns(1).Clear '(Clear contents and formatting)


---
Regards,
Norman


"owl527" wrote in
message ...

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

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 Su

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=54642