Placing range into variable from function

[jtwork]

I have the following formula which returns a cell range.

=INDIRECT("Data!$D$2:$G$"&(65536-(COUNTBLANK(Overall!$A:$A))))

This works when defined using (ctrl+F3)

I would like however to put this into a variable in VB

The following doesnt seem to work

Let myrange =INDIRECT("Data!$D$2:$G$"&(65536-(COUNTBLANK(Overall!$A:$A))))

[Richard Schollar]

Hi

If you really wanted to do it with these parameters then maybe you could use:

Please Login or Register  to view this content.

When assingning object references, you need to use the Set keyowrd, not Let.

Hope this helps!

Richard

[jtwork]

Many thanks for your help got it working