hi all!
It sometimes highlights End With and sometimes highlights Range("C2:C10001").Select
Any idea what the problem might be?
Guy xp prof xl 2007
Sub Text_on_XY()
'AutoFill
Range("C2:C2").AutoFill Destination:=Range("C2:C" & Cells(Rows.Count, "B").End(xlUp).Row)
'Paste formula...