Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I add to a formula in a macro?
I am using a defined name in one cell for a retail price of a product. I use
the same defined name for the wholesale cost of the same product but put a "C" at the end of the name. Example HollywoodHills would be retail, HollywoodHillsC would be wholesale. Is there any way of pulling that defined name for the retail price from one cell on the worksheet and adding the "C" to the formula to place in another cell on the worksheet? I have tryed to copy the cell and PasteSpecial formula to the destination cell, but I do not know if I can add the "C" in the destination cell. Any help out there would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro/Formula help | Excel Worksheet Functions | |||
Need a formula/Macro | Excel Discussion (Misc queries) | |||
Formula Macro | Excel Worksheet Functions | |||
formula to a macro help PLEASE | Excel Discussion (Misc queries) | |||
Macro - formula for end of last row | Excel Worksheet Functions |