Bottom post...
Paul Smith wrote:
Dear All
I am trying to create a macro in Calc to delete everything in the
column C except formulas. I have tried to record the macro as follows:
1. select the whole column C;
2. delete contents, except formulas.
However, the macro only works if I select the column C before running
the macro. Any ideas?
Thanks in advance,
Paul
You can select column C as part of your macro, or you can ... download
my free macro document and read the section titled: Clear A Cell
I asumme that this should be enough information.... Yes, this material
is also in my book, and then some.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
