Copy Worksheets

[AC12]

Seems this should be easy, but I need some help. Two VBA statements. First sends execution to a function in the module, though it should only clear a range. IF I comment that out, second statement sends execution to a different function in the module. What can I be doing wrong?

Sub CopyMySheet()
'Worksheets("TempServe").Range("A1:A500").ClearContents
Worksheets("ProvidedServices").Range("A1:A500").Copy Worksheets("TempServe").Range("A1:A500")

End Sub


Thanks for your help

 

[AC12]

There is no apostrophe to create a comment

 

[AC12]

Oh, Norie, I liked your suggestion, too. And it helped, but then I changed the code -- my efforts to simplify it and it no longer helped. But, I think I do need your application.calculation statements. Ok, now I've put the calculation statements in and the code works as I would expect it to. Thank you Norie, Trevor and My Answer is This. I think I learned a valuable lesson about leaving calculated fields in my data sheets.