Formula by macro error

[ad9051]

Hello many thanks for taking the time to look at my problem,

I'm trying to run a faily large formula via macro but every time I run it I get an error which I am not sure how to fix...

Here is the formula:

Please Login or Register  to view this content.

Here is the forumla in macro form:

Please Login or Register  to view this content.

Error:

Run-time Error '1004':

Application-defined or object-defined error"

Strangely this formula works in the sheet. If anyone can help identify the root of this problem, your help would be greatly appreciated.

Many thanks

Alan

[tigeravatar]

Alan,

Give this a try:

• Formula can be shortened to:

  Please Login or Register  to view this content.

• Macro version:

  Please Login or Register  to view this content.

[ad9051]

TigerAvatar, you really are the boss! I need to learn how to write formula like that! You wouldn't believe how long some of my formula get.

Many thanks

Alan