Multiple If's and Last value in range

[Dagoom]

Hello everyone!

Can anyone help me out with my issue here?

So far this is my code.

Please Login or Register  to view this content.

Now, what I want is instead of it referring to cell A14, it refers to the last cell with data in it in column A.

How would I go about doing this?

I have since posting this, tried to change some code, and here is what I have come up to.

Please Login or Register  to view this content.

And still it isn't selecting the last value in the range.

PLEASE help me out here guys!

[Dagoom]

Got it myself,

This is what made it work!

Please Login or Register  to view this content.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.