Creating Worksheets

[Elemental]

Hi again everybody,

when i copy a range of cells, what code is best used to clear the contents of another worksheet, so when their pasted into it, they dont leave old data from larger ranges pasted previously.

i get the Select Method Of Range Class Failed error,

i have tried

Sheets("Results").Select
Cells.Select
SendKeys ("^A")

==================

Sheets("Results").Select
Range("A1:Z1000").Value=""

and some other stuff, but it doesnt quite work out

perhaps deleting a worksheet, and creating a new one would clear it properly, and then i could just use the destination code to copy the data to.

things is, what kinda code is used ?

 

[RichardS]

Try
Cells.Select
Selection.Clear

Richard

 

[parry]

Hi, I would just replace the sendkeys statement with the following:-

cells.select
Selection.ClearContents
range("a1").select

This should clear it out. However, if you have comments they will still be left there.
Is it just pure data?

----
After seeing above post the selection.clear statement is better as it DOES clear comments as well. Cool.
This message was edited by parry on 2002-08-21 20:18