Variable cell refernces

aboo · #1 (**permalink**) 05-30-06, 22:49

Hey guys,

Is it possible to have a variable cell references? for example in a loop

where i = 2 TO 50

then have a cell reference as B(i)

is this possible?

Thanks

aboo

shades · #2 (**permalink**) 05-31-06, 00:33

Howdy, and welcome to the board.

Yes that is possible, but you may want to include two variables (row and col). There are a couple of ways to do it, but the easiest way is to use Cells. In the following, it is not exactly correct, but you get the idea. If you want the double refernce (Row and Col), then use another For lngCol 2 to 50 statement inside the one below.

Code:

Dim lngRow as Long, lngCol as Long
For lngRow 2 to 50
   Cells(lngRow,lngCol)
Next lngRow

aboo · #3 (**permalink**) 05-31-06, 09:29

Thankyou for your welcome and for your reply. Im going to be buggin you alot.

Internet Services

Web Development

Digital Marketing

Consumer Tech