Having trouble defining variable

[FKoenig]

Hi,

I'm brand new to Mr. Excel so try not to filet me too much if I'm dumb. My question:

I just picked up VBA AND MACROS: Microsoft Excel 2010 and am trying to follow along with some of the basic exercises. I have, however, run into an issue and I don't see what I'm doing wrong.

The book says to set a "FinalRow" variable to the last row in a worksheet.

I've retyped the code as:
FinalRow = Cells(Rows.Count, 1).End(x1Up).Row

Excel/VBA doesn't seem to like it. I get a Run-time error '1004': Application-defined or object-defined error

What am I doing wroing?

 

[p45cal]

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

 

[Jonmo1]

Welcome to the board...

that should be

XLUP

That's an L not the number 1.


Put this at the VERY TOP of your module, before anything else..

Option Explicit


That will help capture those misspelled words..
And it will require you to declare all variables...

Dim FinalRow As Long
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row



Hope that helps.

 

[FKoenig]

Ah..... I'm totally blind. Thanks very much! I swear it looks like a '1' in the book.

 

[Jonmo1]

You will see that throughout VBA...

Just remember who wrote the program..
xl = EXCEL

 

[FKoenig]

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

ps - this did help, and I acknowledge as much.