Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modify an existing Cell formula using VBA
If I have a formula in cell A1 that contains the following: "=C1" ...and I
want to KEEP that formula ("=C1") but also ADD to the end if it the following: "*10" so that it becomes: "=C1*10" using VBA, is that possible? My users need to select ranges of cells and then multiply them *10 but the formulas can't be erased while doing this. Right now I have a simple "For Each MyCell in Selection, MyCell = MyCell*10 but this of course overwrites the formulas if they are present, so it only works for the cells without formulas. Thank You for any advise!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify A formula | Excel Worksheet Functions | |||
Modify a formula | Excel Discussion (Misc queries) | |||
insert a new cell into an existing formula | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
How do I modify an existing worksheet to remove columns & contents | Excel Discussion (Misc queries) |