Re: Clear Cell
From: bandy2000 (bandy2000_at_discussions.microsoft.com)
Date: 03/16/05
- Next message: quartz: "Re: ADO cloned recordset doesn't return field names"
- Previous message: Mike Piazza: "Re: How to zero out cells with formulas in them but no precedents?"
- In reply to: Tom Ogilvy: "Re: Clear Cell"
- Next in thread: Gord Dibben: "Re: Clear Cell"
- Reply: Gord Dibben: "Re: Clear Cell"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Mar 2005 12:55:05 -0800
hi Tom,
no not active cell.
i have different worksheets and have to delete (clear) the complete contents
of
worksheets that are currently not active!
something like
Worksheets("TestSheet").Range.Cells.ClearContents
but this line doesn't work!
"Tom Ogilvy" wrote:
> do you mean other than the activeCell
> v = activecell.Value
> cells.ClearContents
> activeCell.Value = v
>
> --
> Regards,
> Tom Ogilvy
>
> "bandy2000" <bandy2000@discussions.microsoft.com> wrote in message
> news:326B6CEC-BA9C-4DC7-8813-F082C9962D10@microsoft.com...
> > Hi
> > How can I clear all cells of a work*** other than the active work***?
> >
> > Thanks
>
>
>
- Next message: quartz: "Re: ADO cloned recordset doesn't return field names"
- Previous message: Mike Piazza: "Re: How to zero out cells with formulas in them but no precedents?"
- In reply to: Tom Ogilvy: "Re: Clear Cell"
- Next in thread: Gord Dibben: "Re: Clear Cell"
- Reply: Gord Dibben: "Re: Clear Cell"
- Messages sorted by: [ date ] [ thread ]
