Mr. Excel's FinalRow

[diamantebonita]

other than declaring FinalRow as variable, is there something else i should have done?

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

(I'm running the script line by line and i keep getting an error message when i get to this one)

 

[diamantebonita]

I keep getting an application defined or object defined error

 

[njimack]

It should be xlup not x1up

 

[poolhall]

bonita, it is xlUp, not x1Up

 

[diamantebonita]

hahahahahah

Wow, i cant believe i did that! I combed that line over and over and couldnt figure it out.

thanks everyone!

 

[njimack]

Here's a tip for avoiding typos - enter everything in lower case. After pressing enter, the code will automatically capitalise letters that should be capital. If it doesn't, you've mistyped something.

 

[shg]

if you put Option Explicit at the top of every module, the VBE will tell you what it doesn't recognize.