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