| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to re-write all cells in a column
columns(3).copy
columns(3).Pastespecial xlValues or set rng = Range(Cells(1,3),Cells(rows.count,3).end(xlup)) for each cell in rng cell.formula = cell.Value Next adjust for formulas. -- Regards, Tom Ogilvy "Bob L" wrote in message ... I would like some help writing a macro to rewrite all the contents of the cells for an entire column. Is this possible? Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Macro to re-write all cells in a column | Excel Programming | |||
| Macro to re-write all cells in a column | Excel Programming | |||
| Write a macro to populate a column with a formula | Excel Programming | |||
| Write a macro ro copy column at certain time of day. | Excel Programming | |||
Hybrid Mode
