Re: ClearContents does not work...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Miguel,
Thank you for your reply.
My code is in a module. Adding the Workbookname did not work either...

"Liedson31" <Liedson31@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8EBE8AE5-1B17-4525-854E-3F0A968019A7@xxxxxxxxxxxxxxxx
> hi kjartan....
> yes the code you have is ok....it works...
> 1 questions:
> are you running this one in the workbook you want to "clearcontents"
>
> if you don´t you have to put:
> workbooks("workbookname").Worksheets("Sheet1").Range("F1:F15").ClearContents
>
> cheers
> Miguel
>
> "Kjartan" wrote:
>
>> To make 'Empty' cells I expected this to work:
>>
>> Worksheets("Sheet1").Range("F1:F15").ClearContents
>>
>> .... but it does nothing... does not even clear numbers in those cells.
>> Do I need to use another method for this purpose ?
>>
>>
>> Thank's,
>> Kjartan
>>
>>
>>


.

Relevant Pages

  • Re: ClearContents does not work...
    ... Adding the Workbookname did not work either... ... >>> Kjartan ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: INDEX MATCH formula
    ... As Miguel said, use something like ... play with the cells to get the correct value. ... (remove xxx from email address if mailing direct) ... worksheet page made up of practice codes which are numbered in rows ...
    (microsoft.public.excel.worksheet.functions)
  • RE: =Countif(range, criteria)
    ... Jim Thomlinson ... "Miguel" wrote: ... particular cells that have a Fill Color in them. ... Now on the criteria I want ...
    (microsoft.public.excel.misc)
  • RE: =Countif(range, criteria)
    ... you may need an UDF for that. ... "Miguel" wrote: ... particular cells that have a Fill Color in them. ...
    (microsoft.public.excel.misc)
  • Re: Cell Array
    ... I am creating a cell array in two different ways: ... Is there any difference the way I create both cells. ... Miguel ... Prev by Date: ...
    (comp.soft-sys.matlab)