.
- Original Message
From: hanumant shinde arsfan2...@yahoo.co.in
To: excel-macros@googlegroups.com
Sent: Mon, 11 July, 2011 1:11:23 AM
Subject: Re: $$Excel-Macros$$ Strange Issue with Macro
Hi,
i m increasing the range by code
- Original Message
From: Rajan_Verma
Sent: Mon, 11 July, 2011 1:11:23 AM
Subject: Re: $$Excel-Macros$$ Strange Issue with Macro
Hi,
i m increasing the range by code
- Original Message
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sun, 10 July, 2011 9:25:24 PM
...@yahoo.co.in
Subject: Re: $$Excel-Macros$$ Strange Issue with Macro
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
Hi,
i m increasing the range by code
- Original Message
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sun, 10 July, 2011 9:25:24 PM
Subject: RE: $$Excel-Macros$$ Strange Issue with Macro
How Did u increase range by code or by name wizard
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
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
coz its in the office pc i dont have it n i cannot hav it
at
home :(.
- Original Message
From: Dilip Pandey dilipan...@gmail.com
To: excel-macros@googlegroups.com
Cc: arsfan2...@yahoo.co.in
Sent: Sat, 9 July, 2011 5:55:10 PM
Subject: Re: $$Excel-Macros$$ Strange Issue with Macro