Hi all,

I have named my Workbook an ingredient name i.e. APPLE. I would like to be able to reference APPLE into a cell. How can I do this with VBA?

It feels simple enough, but I haven't been able to find much information online...

Thanks for your help in advance!

Kind regards,

Lou