424 Error

[rpjwhite]

All

So I am using a lookup table to calculate a date and Iam getting stuck on a 424 error. I am pretty sure I dim'd the hold values at the start no dice. I have tried to remove the holding numbers but again no play...

Please Login or Register  to view this content.

[AliGW]

A quick Google suggests you should check for misspellings.

[alansidman]

Also, if you click on debug when you get the error, Excel should highlight the line of code where the error is occurring.

[rpjwhite]

I will give that a shot spelling is not my strong point.

[rpjwhite]

@alan I did that. I have commented the dodgy line.

[Norie]

If this is the problem line you should split out the Application.Match parts to make things easier to debug.

Please Login or Register  to view this content.

For example.

Please Login or Register  to view this content.

[rpjwhite]

@Norie yeah that seemed to work. Now trying to work out why it is erroring...