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))))