Hello:
I am using below code :
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.
Please Login or Register to view this content.
Let me know if you have any questions.
Thanks.
Riz
If SRange is a positive number then you could use
However, how do you want to handle these situations.Please Login or Register to view this content.
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
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Try
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hello YasserKhalil:
I have tried your solution but it gives error as attached...
Hello mikerickson:
I get mismatch error with your solution.
Please let me know if you have any questions.
Thanks.
R
What is the value of SRange when that error occurs?
Hello mikericson and Yasser:
Your solution works.
Thanks a lot..
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks