Should work fine. You wall get a type mismatch error if you try to use a
string variable, it needs to be variant,

Dim filename

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
i just ended up using this

Fname = Worksheets("tellers").Cells(i, 2).Value

For i = 2 To 20
Range("B4").Formula = Range("B4").Formula & "+'" & fPath & Fname &
"Trans'!$F4"
more lines like above
next i

--


Gary


"Bob Phillips" wrote in message
...
Dim vformula
vformula = Range("B1:B20")

...

MsgBox vformula(3,1)


it loads the array dynamically, but is a 2D array.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" wrote in message
...
right now i have a few variables explicitly set in a summary workbook:

filename$(1) = "[workbook1.xls]"
........
to.
.......
filename$(20) = "[workbook20.xls]"


what i want to do is list the filenames on a separate sheet in the
summary
workbook so i can mange them more easily

how would i set the above variables to reference a cell's value
(b1:b20)
on
that sheet?

thanks
--


Gary