HURTMYPONY
Board Regular
- Joined
- Oct 27, 2003
- Messages
- 166
I have this bit of code:
And I would like it to work with the SourceCloser sheet's CodeName (sheet13) instead of the sheet name.
What is the correct syntax? I tried a few variations, but none work...
Code:
Dim LC As Long
With Sheets("SourceCloser")
LC = .Cells(4, Columns.Count).End(xlToLeft).Column
.Range("C5:C90").Copy Destination:=.Range(.Cells(5, 4), .Cells(5, LC))
End With
And I would like it to work with the SourceCloser sheet's CodeName (sheet13) instead of the sheet name.
What is the correct syntax? I tried a few variations, but none work...