Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formats from row 2 down to nRows
Hi
I'm trying to copy row 2 and copy the formats down the sheet to the last row (I have already defined nRows). I'm having trouble selecting the nRows to paste into... Rows("2:2").Select Selection.Copy Rows("3:3 & nRows").Select Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to copy formats | Excel Discussion (Misc queries) | |||
copy formats vlookup | Excel Worksheet Functions | |||
nRows range within SUMIF | Excel Programming | |||
Copy Number Formats | Excel Programming | |||
using array to copy formats as well... | Excel Programming |