Can't assign price/date from another cell to variable

Hi,

A fairly basic question. I'm getting a 'runtime error 13: type mismatch' when I tried assigning a price or date from another cell to a variable.

I've tried the following:

Please Login or Register  to view this content.

I need to assign the variable while I am running a 'For each [cell] in [range]' loop, so I'll need to assign a new value to the variable for each leg of the loop. I've declared Date1 as a date.

Hope that that's sufficiently clear, forgive my bad programming grammar, I'm pretty new to the scene. Ideas?

Thanks,

vanckzhu

EDIT: Never mind, I was being an idiot. My problem was not with the variables, it was with the select case code.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here