- Deleted by Luke M
- Reason: Question answered
i Luke,
Thanks for the reply. This is not working, Reference will be name of sheet which is chosen dynamically based on selection in List Box. Example: "'"&Reference&"'!A:A" evaluates to "'"&sheet1&"'!A:A" if selection in list box is sheet1.
While debuging i found that Query is formed but evaluates to null.
Is there any issue with strings or so?
Regards,
Arun
Thanks for the reply. This is not working, Reference will be name of sheet which is chosen dynamically based on selection in List Box. Example: "'"&Reference&"'!A:A" evaluates to "'"&sheet1&"'!A:A" if selection in list box is sheet1.
While debuging i found that Query is formed but evaluates to null.
Is there any issue with strings or so?
Regards,
Arun