Hi Hanumant
It is interesting..
I am assuming that code first changes the range for the name and then
the same is getting used. Try changing the order or refresh
(Calculate) the sheet.
If possible, share the test file.
Best Regards,
DILIPandey
On 7/9/11, hanumant shinde <arsfan2...@yahoo.co.in> wrote:
> Hi friends,
>
> i have a file in which there are 2 sheets. sheet A and B. i am giving name
> ranges in sheet B as below.
>
>
> A1:A20 - "Range1"
> B1:B20 - "Range2"
> C1:C20 - "Range3"
> D1:D20 - "Range4"
> these name ranges are used in Sheer A.for data validation
> programatically i am increasing these ranges by 10 rows
>
> A1:A30 - "Range1"
> B1:B30 - "Range2"
> C1:C30 - "Range3"
> D1:D30 - "Range4"
>
> after increasing the ranges if i do Range("Range1").Select for all ranges
> then
> proper range is getting selected i.e. from 1 to 30. BUT when i used the same
> range in data validation then some of the ranges are using OLD values i.e.
> lets
> say for data validation ranges used are like below
>
> A1:A30 - "Range1" - Right
> B1:B30 - "Range2" - Right
> C1:C20 - "Range3" - Wrong
> D1:D20 - "Range4" - Wrong
>
> can anybody please tell me why that would happen.
> this is very strange issue i saw my code is getting executed for increasing
> the
> range and its working fine. but still i m facing his issue. ANY help would
> help
> me a lot.
>
> thanks
>
> --
> ----------------------------------------------------------------------------------
> 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 excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
