Re: Referencing a Range of Cells with Named Columns and Target.Row
Thanks everyone. M40wen, unfortunately that was giving me the following error: Run-time error '438': Object doesn't support this property or method. It did however point me in the right direction as I hadn't come across the .address property before. I've now managed to get the following code working.