Variable in Range...

[rizmomin]

Hello:

I am using below code :

Please Login or Register  to view this content.

I need code : Set r = Range("A138", Range("A" & Rows.Count).End(xlUp)) to be changed so that A138 becomes variable and pick the value as SRange as defined above.

Let me know if you have any questions.
Thanks.

Riz

[mikerickson]

If SRange is a positive number then you could use

Please Login or Register  to view this content.

However, how do you want to handle these situations.

1) B1 contains a string or a bad number (e.g. -12) or an error value (e.g. #DIV/0)

2) sRange is larger than Cells(Rows.Count,1).End(xlup).Row

[YasserKhalil]

Try

Please Login or Register  to view this content.

[rizmomin]

Hello YasserKhalil:

I have tried your solution but it gives error as attached...

[rizmomin]

Hello mikerickson:

I get mismatch error with your solution.
Please let me know if you have any questions.
Thanks.

R

[mikerickson]

What is the value of SRange when that error occurs?

[rizmomin]

Hello mikericson and Yasser:

Your solution works.
Thanks a lot..

Riz