Shailender
Member
Here is the question, I have attached two sheets Sheet1 & Sheet2 . I want to select the last used cell from the selected range, here my range is yellow color one.
In this case I have colored the cell in red color that is the result I want. This cell may vary I mean it suppose to be in any other column (C,D,E,F,g,h)
Once that is selected I want to select the range from (A1 to last used cell from the selected range). For you reference I've attached two sheets.
Hope the question is clear. Thank you in advance.
In this case I have colored the cell in red color that is the result I want. This cell may vary I mean it suppose to be in any other column (C,D,E,F,g,h)
Once that is selected I want to select the range from (A1 to last used cell from the selected range). For you reference I've attached two sheets.
Hope the question is clear. Thank you in advance.