Use this Code
Sub range()
R = Application.WorksheetFunction.CountA(RANGE(A1:A65536))
RANGE(A1:B R).Select
End Sub
On May 19, 2:40 pm, SANJAY SONI sanjaysoni2...@yahoo.co.in wrote:
Dear All,
Please help me to provide a macro code for selecting a variable range.
Suppose for example
Hi Ashish,
This below code might help you.
lstrow = Range(A65000).End(xlUp).Row
Range(A1: B lstrow).Select
On Wed, May 19, 2010 at 10:40 AM, SANJAY SONI sanjaysoni2...@yahoo.co.inwrote:
Dear All,
Please help me to provide a macro code for selecting a variable range.
Suppose for
Dear All,
Please help me to provide a macro code for selecting a variable range.
Suppose for example the data enter from (A1:B10) but if the more data
is entered into a cell by changing a range to (A1:B20) or (A1:B18).
Thanks in advance
Please provide solicit inputs if you can
Sanjay