divingdingo
11-22-2007, 04:50 AM
thanks to one and all, who have continued to help me in the last week or so. it's a steep VBA learning curve out there but i seem to be getting somewhere...slowly!
my problem today rears it's ugly head with the solver add-in that i continuously use on my wind-data.
so in my work sheet i've recorded a macro of what i do, then checked the vba code against other solver problems i've seen on the web to check its layout and correctness.
it seems to be fine, however when i run this code i'm getting the horrid yellow highlighter defining the whole sub with the message box that says:
"compile error: sub or function not defined"
however if i take ou the section which has the solver code in, then the macro works fine.
any theories on this one would be as always hugely appreciated
mark
my problem today rears it's ugly head with the solver add-in that i continuously use on my wind-data.
so in my work sheet i've recorded a macro of what i do, then checked the vba code against other solver problems i've seen on the web to check its layout and correctness.
it seems to be fine, however when i run this code i'm getting the horrid yellow highlighter defining the whole sub with the message box that says:
"compile error: sub or function not defined"
however if i take ou the section which has the solver code in, then the macro works fine.
any theories on this one would be as always hugely appreciated
mark