Run-time Error '1004' application defined or object defined error

[Ody]

That's the error I keep getting and for the life of me can't figure out why. Any thoughts? Thanks.

Dim LastSheet As String
LastSheet = Worksheets(Worksheets.Count).Name
With Worksheets("Summary")
lMaxRows = .Cells(.Rows.Count, "q").End(xlUp).Row
.Range("q" & lMaxRows + 1).Formula = "=text('" & LastSheet & "'!BO49/& '" & LastSheet & "'!BJ49,""0%"")"
End With

 

[Jonmo1]

Extra &

.Range("q" & lMaxRows + 1).Formula = "=text('" & LastSheet & "'!BO49/& '" & LastSheet & "'!BJ49,""0%"")"

 

[RSXchin]

A great way to find out if you got the syntax right for formulas, is to take out the '=' in the formula. then look at the text. Works wonders if you're bad at double and triple quoting like me.

 

[Ody]

It's always the little things!

Thanks for the extra eyes