Goal seeking in VBA 1

[Noo]

Hi

Please help me!!!

I've written a simple macro which invlolves code to do a goalseek. It works perfectly if I run it from the tools menu in excel. (Tools>macros>macros)

However, if I connect the macro (Sub) to a commandButton or call it from another macro it gives me the error ("Run time error 1004: goalseek method of rangeclass failed&quot.

Please help
Thanks
Noo

 

[DarkSun]

Try putting this at the beginning of the Sub:

Selection.Activate

If that doesn't work can you paste your code so we can have a look at it.