vinzent
New Member
- Joined
- Feb 7, 2012
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Hello!
I have this problem with my macro: I want to copy the format from "Old Tab" to "New Tab", from column N to column AB but I am not shure how apply until last row with data in "New Tab".
This is my macro at this moment:
If you can help me....Thanks in advanced!!
I have this problem with my macro: I want to copy the format from "Old Tab" to "New Tab", from column N to column AB but I am not shure how apply until last row with data in "New Tab".
This is my macro at this moment:
VBA Code:
'Sheets("Old Tab").Range("N2:AB2").Copy
ActiveSheet.Range("N2").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
If you can help me....Thanks in advanced!!