Run-time error

[iwilli]

New guy back again. I'm trying to clean up my macro I made using the recorder. This is the code and I get a Run-time error '1004': Application-defined or object-defined error. I don't know enough to know what the error is or how to fix it. For what it is worth the code is the very first thing in the macro. I was trying to type a column name in row F that says "AO Name" in F1. What am I doing wrong?

'   Find the last row with data. This might change every day
    FinalRow = Cells(Rows.Count, 1).End(x1Up).Row
    TotalRow = FinalRow + 1
    Range("F" & TotalRow).Value = "AO Name"

 

[Jonmo1]

Welcome to the board..

FinalRow = Cells(Rows.Count, 1).End(x1Up).Row
should be
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row

It's the letter L, not the number One.


Hope that helps.

 

[iwilli]

Thanks! It solved the run-time error. It enters the "AO Name" in the last row and I want it in B2. What can I change to get this to work?

 

[Jonmo1]

Try

Range("B2").Value = "AO Name"

 

[iwilli]

This is perfect! It works great.

 

[Jonmo1]

Glad to help, thanks for the feedback.