Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values and formatting but not formulae to new worksheet with VBA
I want to select a subset of cells from a complicated worksheet and
copy just the values and formatting from those cells to a new worksheet programatically. The cells have conditional formatting, which I would like to have come over as well. I would also like the new worksheet to be formatted (column width, cell height, etc.) exactly as the source worksheet. Is there any way to do this? I know how to create a new empty worksheet programatically, and I've experimented with various ways of copying cells, and I can get the values to come over with, e.g.: Worksheets(5).Range("A" & 1 & ":H" & LastRow - FirstRow).Value = Worksheets(4).Range("A" & FirstRow & ":H" & LastRow).Value But I can't figure out how to get the conditional formatting, cell widths and heights, etc., to come over to the new worksheet. Any tips would be much appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values and formatting but not formulae to new worksheet with VBA
Rowan Drummond wrote
For Each cell In Sheets(1).UsedRange cell.Value = cell.Value Next cell FWIW, my experience has been I can write this as: Sheets(1).UsedRange.Value = Sheets(1).UsedRange.Value -- David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values and formatting but not formulae to new worksheet with VBA
Thanks, that solves it exactly.
David wrote: Rowan Drummond wrote For Each cell In Sheets(1).UsedRange cell.Value = cell.Value Next cell FWIW, my experience has been I can write this as: Sheets(1).UsedRange.Value = Sheets(1).UsedRange.Value -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulae | Excel Worksheet Functions | |||
Copying Formatting from one Worksheet to another within different | Excel Discussion (Misc queries) | |||
copying an entire worksheet - need absolute values | Excel Worksheet Functions | |||
Hided values appears when I'm copying/pasting it to other worksheet | Excel Discussion (Misc queries) | |||
(Newbie) Copying values from an array to the worksheet | Excel Programming |