| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
