Using Defined Workbooks and Worksheets in a VBA Formula

[Althas]

Hello all, I hope this makes sense

I am trying to write a formula in VBA using ranges on different workbooks and worksheets

The defined names I have are
CodeBook (Workbook)
DataBook (Workbook)
DataSheet (Worksheet in DataBook)

DataBook has multiple worksheets in it, but the one i want to use for this formula is the DataSheet one

So the formula I am trying to do is written in CodeBook, and links to DataBook>DataSheet>D1:D11

Normally of course I would just put ='[DataBook]DataSheet'!D1:D11 in a formula when i type it directly into a cell, but can not seem to get this working in VBA

So can anyone please explain how to refer to these referenced workbooks and sheets in a VBA formula

Thank you

[Bob Phillips]

Maybe try something like

Please Login or Register  to view this content.

[ragulduy]

possible something like:

Please Login or Register  to view this content.