Selecting last row

[kosherboy]

Hello all.
This part of my code is causing errors:

Please Login or Register  to view this content.

[Kaper]

I don't know how is defined LR, neither what is assigned to it, neither what is the error message, but if line ather Then works, try the following after Else:

Please Login or Register  to view this content.

[kosherboy]

Oh whooops! I forgot to define the last row. How silly
i'll let you know if my code works.

[kosherboy]

Unfortunately neither the code you posted or defining the last row worked
This is how i am defining the last row:

Please Login or Register  to view this content.

Any other ideas?

[Hellis]

LR is only a number.
Range needs a column too.
I believe you should use Rows(LR).select
Or something like it , at work now typing on my phone so I can't test it.

[kosherboy]

Thanks.
I tried it but it didn't work.

[mmmarks]

Have you declared a LR as variable.

Please Login or Register  to view this content.

[kosherboy]

Yes, i did

[Hellis]

Google

http://www.google.se/search?hl=en&re...ect+row+number

[kosherboy]

Here is my entire code (sorry )i made the font of the issue in the code red:

Please Login or Register  to view this content.

[excelsias]

Hi kosherboy, I hope this video would help.

https://www.youtube.com/watch?v=K0VqyXLJBOw