HI, I have done this code 100 times and it always works, it works in 3 other subs in the same workbook. I can't work out why I get an object defined error on it on this line:
Code
air_start_row = Sheets("Accommodation Analysis").UsedRange.SpecialCells(xlCellTypeLastCell).Offset(1).Row
Debug.Print Sheets("Accommodation Analysis").Range("C", CStr(air_start_row))
Possibly it's too early and I am making a rookie mistake!!
If anyone can spot it, then please feel free to help out.
Dave