Invalid or unqualified reference error
 

Getting Invalid or unqualified reference error

Sub wordwrap()

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

End Sub

Invalid or unqualified reference error
 

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