Assign number to variable in VBA?

**Jalupeno104** · 06-08-2009, 09:26 AM

Hey guys,

I'm having trouble assigning the value 2 to my x variable. I have a little bit of experience in C++ and none in VBA, so this is probably a stupid mistake. Here is my code:

Please Login or Register  to view this content.

Thanks guys.

**shg** · 06-08-2009, 09:32 AM

There's nothing wrong with your assignment.

In VBA, variables types should be declared appropriate to usage; e.g., if sourcecell is intended to be a range, it should be declared as a Range.

**Jalupeno104** · 06-08-2009, 11:21 AM

Thanks for the help, I replaced the "cells(x, 2)" with "range("B" & x)" and the program ran. Unfortunately, it gave me an overflow message. I do not think I am approaching this problem in the right method. Here is a link to my problem that I'm trying to solve. If anyone can help, it would mean the world. Thanks!