On 9/21/05, Andrew Douglas Pitonyak <[EMAIL PROTECTED]> wrote: > >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? > > > 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.
Thanks, Andrew. I have used the "record macro" facility and it does not work if one selects the entire column C by clicking on C. However, this method works fine when one only wants to select a piece of the column C. Thus, I did so and then I hacked the macro replacing the line args2(0).Value = "$C$1:$C$17" with the line args2(0).Value = "$C$1:$C$65536" By doing so, I am selecting the entire column C, which has only 65536 cells. It works! Paul --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
