ExcelBanter - Invalid or unqualified reference error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Invalid or unqualified reference error (https://www.excelbanter.com/excel-programming/425219-invalid-unqualified-reference-error.html)

Stanley Braverman

Invalid or unqualified reference error

Getting Invalid or unqualified reference error at .Cells

Sub wordwrap()

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

End Sub

All times are GMT +1. The time now is 11:55 PM.