Thanks for your help, I'm stil getting an error in the code it seems. The error was Method 'Range' of object '_Worksheets' failed. wks.name properly referenced the sheet but the code stopped at iCol with a value of '0'.

What am i missing still? Does the sheet need to be activated for it to reference a cell and count?

Thanks again