VBA Copy Paste to another WS not working

[psrs0810]

I am not understanding why my copy from one ws (entire ws) to another Ws is not working. Please help

Thanks

Sheets("ChargeDetail8").Cells.ClearContents
Sheets("ChargeDetail7").Cells.Select
Selection.Copy
Sheets("ChargeDetail8").Select
Range("A1").PasteSpecial Paste:=xlValues

Sheets("ChargeDetail7").Cells.ClearContents
Sheets("ChargeDetail6").Cells.Select
Selection.Copy
Sheets("ChargeDetail7").Select
Range("A1").PasteSpecial Paste:=xlValues

 

[Joe4]

You can do it quite simply like this:

Sheets("ChargeDetail8").Cells.ClearContents
Sheets("ChargeDetail7").Cells.Copy Sheets("ChargeDetail8").Range("A1")


Sheets("ChargeDetail7").Cells.ClearContents
Sheets("ChargeDetail6").Cells.Copy Sheets("ChargeDetail7").Range("A1")

 

[psrs0810]

awesome - thanks

 

[Joe4]

You are welcome!