macro clearing wrong worksheet

[nigelog]

The attached macro populated a worksheet summary from a main database. I then wanted to make it clear the worksheet first before overwriting.

The default worksheet on opening file is "DriverDetails" so how the bottom half of the macro populated "DataSAFEPASS" without referencing it, I dont know but it did.

Now I am trying to reference the sheet "DataSAFEPASS" to clear contents and added a message box after re referencing "DriverDetails" - it is clearing the wrong the wrong sheet. What am I Missing.

Any help appreciated

Please Login or Register  to view this content.

[cytop]

You need to qualify the Range statement with a '.' (dot) to indicate it applies to the object specified in the With statement

Please Login or Register  to view this content.

As far as the Copy line goes the unreferenced range will apply to the active worksheet. That may be what you want but you should always explicitly reference the worksheet the Copy command is to use as the source, same as you do for the destination.