Getting Invalid or unqualified reference error

Sub wordwrap()

Sheets("Sheet1").rows("1:" & .Cells(.rows.Count, "A").End(xlUp).Row).AutoFit

End Sub

probably becasue of .Cells and .rows.Count
remove dot and leave only Cells

also you need an explicit reference for .rows.Count

UsedRange.rows.Count might be an option



On 5 Mar, 19:08, "Stanley Braverman" wrote:
Getting Invalid or unqualified reference error

Sub wordwrap()

Sheets("Sheet1").rows("1:" & .Cells(.rows.Count, "A").End(xlUp).Row).AutoFit

End Sub