Variable not assigning properly

[JasonLeisemann]

Okay, hopefully this'll turn out to be a quick and easy one. And, in so saying, I'm sure that I've just turned it into a real mess.

So, I'm trying to set up a check so that my allocation sheet will tell me if I've got rounding errors that will throw me off. And, fortunately, in my sample I do!

So in my macro, I have the following code:

Please Login or Register  to view this content.

My problem pops up on the second line; when I'm assigning the lngAllocTot value, it's pulling a 1, rather than a 1.000001, as I have in my spreadsheet (and in my immediate window, when I check to see if I'm pulling the right cell). And I double checked, I did assign the variable as a Long value, not an Int value.

Any thoughts?

[Izandol]

Long = Long Integer. I think you require a Double.

[JasonLeisemann]

Long = Long Integer. I think you require a Double.

Which I just realized 30 seconds ago and dearly hoped I could get here to delete the thread before anybody else saw it.

I think I'll chalk that one up to not having enough caffeine yet this morning, and go remedy the situation. Thanks!