Hi everyone,
I'm trying to use a count formula on my worksheet to tell VBA the range of columns I want to copy. This will change between different data sets. I've got the last column number on my "Home" sheet and the range to copy is on the "Calculation" sheet.
I'm not sure why the below isn't...