Hi Vaibhav,
You can use DYNAMIC NAMED RANGES or END Function.
1. Dynamic Named Range
=OFFSET(Sheet1!A1,0,0,COUNTA(Sheet1!$A:$A),1
Please refer Microsoft Help for Offset function to better understand
the arguments.
2. VBA END Function
You can determine last row instead of hard coding in your logic,
similar to this:
Range("A1048576").End(xlup).Row
or
Range("A1048576").End(xlup).offset(1,0).Row
Feel free to write, if further help required on this...
________________________________________
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
________________________________________
On Nov 4, 7:01 pm, vebhav jain <[email protected]> wrote:
> Hi All,
>
> With the help of macros, i recorded the whole data. The problem is that data
> keep varying every day and i have to adjust the data manually everyday to
> run the macros. Please can you suggest better way to take the data, instead
> of changing manually everyday.
>
> Example.
>
> Column A has 450 data on 1st november
>
> Next day
> Column A has 456 data......so i dont want to change the macros data everyday
> manually.
>
> I hope you understood my query.
>
> Thanks
> Vebhav Jain
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
