I have a spreadsheet that contains many sheets and there are references
to particular ranges all over the place. My aim is to remove a lot of
the sheets to an external spreadsheet. I don't want to create named
ranges as this would take too much time setting up specific range
values. So I want to simply change the reference to an external
spreadsheet. An example,

I would like to change,
form.RowSource = "Functions!a1:a54"

to (using H:\[template.xls] as an example)

FunctionFormSelector.RowSource = "H:\[template.xls]Functions!a1:a54"
(this returns a "Cannot set RowSource property" error, but is just an
example as it will be reference elsewhere and not just when setting
rowsource)

I have searched excel's comprehensive help and haven't been able to
find anything. Any clues on correct syntax?

Thanks


--
shawnvb
------------------------------------------------------------------------
shawnvb's Profile: http://www.excelforum.com/member.php...o&userid=16810
View this thread: http://www.excelforum.com/showthread...hreadid=320066