Invalid or unqualified reference error

[Stanley Braverman]

Getting Invalid or unqualified reference error at .Cells

Sub wordwrap()

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

End Sub

 

[Leith Ross]

Getting Invalid or unqualified reference error at .Cells

Sub wordwrap()

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

End Sub

Hello Stanley,

The period indicates the code statement expects that the Paren
qualifier has been declared in a With statement. See below...

----------------------------------------------------
Sub wordwrap()

With Sheets("Sheet1")
.Rows("1:" & .Cells(.Rows.Count, "A").End(xlUp).Row).Autofit
End With

End Sub
---------------------------------------------------

--
Leith Ros

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/