linking problem.. [Archive] - VBA Express Forum

View Full Version : linking problem..

JmE

11-27-2007, 11:50 AM

i want to link to another sheet.. but i want to take the sheetname from a cell? like =B12!B18 :P

=Blad1!B18

RichardSchollar

11-27-2007, 01:12 PM

Hi

You can do this using INDIRECT:

=INDIRECT("'" & B12 & "'!B18")

Richard

JmE

11-27-2007, 10:06 PM

Hi

You can do this using INDIRECT:

=INDIRECT("'" & B12 & "'!B18")

Richard

thx (: