sherylserran
New Member
- Joined
- Jul 19, 2012
- Messages
- 2
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.
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.