| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Better way to apply change to column of values
I have a column with dates and times. I want to take the
date out. So I'm doing it like this: For each Cell in ActiveSheet.Range("A2:A10000") Cell.Value = Cell.Value - Int(Cell.Value) Next Cell This works, but it adds minutes to the procedure. Is there a statement or other that will just make the change to the entire range at once? tod |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change values in a column | Excel Discussion (Misc queries) | |||
| How can I change all negative values in a column to = 0? | Excel Worksheet Functions | |||
| macro to change multiple values in a column | Excel Discussion (Misc queries) | |||
| Change all values in an excel column at once? | Excel Discussion (Misc queries) | |||
| How do I apply a Function to a column of cells and change there va | New Users to Excel | |||
Threaded Mode
