VBA Error i dont understand

**Sparkplug90** · 02-12-2013, 05:19 PM

ok i have some code..using option explicit and an error writer i know the error is an undefined lable but i dont see any

Please Login or Register  to view this content.

**jaslake** · 02-12-2013, 05:28 PM

Hi Sparkplug90

Is this a Named Range

Please Login or Register  to view this content.

and this

Please Login or Register  to view this content.

and this

Please Login or Register  to view this content.

I'd suggest using Long for this

Please Login or Register  to view this content.

Why? Google on integer limits excel vba.

Re: VBA Error i dont understand