Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assigning value in macro
Hi
When I want a value for of a formula for my macro I write the formula to go in a blank cell eg range("a1") ="= countif("b:b",b1)" then use myvalue = range("a1") how do I assign countif to myvalue without doing this? Thanks Tina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assigning macro | Excel Discussion (Misc queries) | |||
assigning a macro to a button | Excel Discussion (Misc queries) | |||
Macro assigning help PLEASE | Excel Programming | |||
Assigning Macro To Shape | Excel Programming | |||
Assigning formula using a macro | Excel Programming |