VBA Ranges

[george hart]

Hi

The code below works fine, yet I want to change my range to C:\Documents and Settings\HartG\My Documents\Projects\Sickness\LookUp.xls.

Dim myRange As Range
Set myRange = Workbooks("LookUp.xls").Worksheets("Lookup Table").Range("B:K")

Any ideas most wwelcome...

Many thanks in advance.

 

[GTO]

By chance, is the workbook you want to reference closed?

 

[george hart]

Yes, the workbook is closed.

The issue I have, is that the workbook in question is maintained eslwhere and quite large...

 

[GTO]

I am afraid you need it open to be able to set a reference to any objects (the range) therein.

 

[george hart]

Oh...that's a shame. There must be a way!!!!!!!!!!