Hello Everyone,
I am trying to copy a named range "GradeReportHeadings" located on another sheet to the active sheet and transpose the data. I am using the following syntax but am getting an error:
GradeReportHeadings.Copy
ActiveSheet.Range("B5").PasteSpecial (Paste = xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Application.CutCopyMode = False
---------------------------------------------------------------
The a regular copy and paste works so I know that I can narrow down my error to the code above. Any ideas would be much appreciated. Thanks--Scott
Bookmarks