Select Method of Worksheet Class Failed

[sherylserran]

I have an existing excel template which is working fine. We just added some tabs and incorporate on the macro, then I encounter the error.

When I try to debug the error is with the 2nd line as per below (in bold font and underlined)
It says that Identifier under cursor is not recognized.

ActiveSheet.Range("$A$5").Select
ActiveCell.CurrentRegion.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("A1").Select

Please help, I do not know what to do with this.


Thanks.

 

[RoryA]

Does it help if you skip all that selecting:

With ActiveSheet.Range("$A$5").CurrentRegion
.Value = .Value
End With

 

[sherylserran]

Thanks, Rory.

I tried to replace the code I made with the code you gave, a new error message showed up

Method 'Select of object'_Worksheet' Failed

Still dont' know what to do.

 

[RoryA]

There weren't any select statements in my code, so what line caused that error? (are you trying to select a hidden sheet?)