| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Copy formats and formulas in vba?
The following statement copies the formulas in one range to another range of
cells. How can I also copy the formats of "ExpRow"? Thank you. .... r = Range("MtrCounter").Value c = Range("ExpRow").Columns.Count With Sheet2 .Range(.Cells(1, 1), .Cells(r, c)) = Range("ExpRow").Formula End With .... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
| Using VB Copy Entire Row but formulas and formats only no values | Excel Discussion (Misc queries) | |||
| What's the best way to add a row and copy formulas and formats? | Excel Discussion (Misc queries) | |||
| Looking to copy a worksheet with all formats and formulas without coping inputed data | Excel Discussion (Misc queries) | |||
| How to have formulas and formats auto copy to new inserted rows | Excel Discussion (Misc queries) | |||
Threaded Mode
