Invalid Qualifier Error Question

[LambChoptheKid]

Hey all,

I've had some success writing some simple VBA programs in the past, and right now I'm trying to make a VERY simple function that simply selects the last cell in Column A of my Worksheet "Test". Picture below.

Now I've written programs more complex than this before using these exact same variables of ws and lastRow to perform modifications to cells under the last used row, yet when I use them to try to simply select the final value in the row it doesn't seem to work and throws the Invalid Qualifier error.

What gives??

Any help would be appreciated. I'm sure the solution is simple but I work in an isolated environment and I cannot seem to wrap my head around why this isn't working.

I'd be happy to provide more details if necessary.

 

[Fluff]

It needs to be

Rows(LastRow).Select

 

[LambChoptheKid]

It needs to be

Rows(LastRow).Select

Thank you! This comes very close to what I'm after.

This succeeds in selecting the last row with data, but I'm only wanting to select the last cell in column A with data. Any idea as to what modifications I could make to make that happen?

Thank you for the reply!

 

[Fluff]

How about

Range("A" & LastRow).Select

 

[LambChoptheKid]

How about

Range("A" & LastRow).Select

Perfect. Thank you so much for the assistance.

 

[Fluff]

You're welcome & thanks for the feedback.