| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using formula =sum('*'!A1) in a macro does not work.
I am trying to use the formula above in a macro that is ran once a button is
clicked. the problem is that the formula goes from =sum('*'!A1) to =sum('*''!A1'), this results in an error message (#NAME), does anyone know why this is happening when it is used in a macro? If i use this in a cell and type it myself it works great! Thanks in advance, TG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
| Can a macro be made to work based on a formula? | Excel Discussion (Misc queries) | |||
| Can a macro be made to work based on a formula? | Excel Discussion (Misc queries) | |||
| formula does not work in macro | Excel Programming | |||
Threaded Mode
