The syntax for referring to named ranges is Range({Name of Named
Range}). Also, I would strong recommend to work with Option Explicit
which will require you to explicitly declare your variables. That
makes your code easier to read and maintain. Give this a try:
Option Explicit
Private Sub
Dear Suresh
The same way how you created name i.e. from A1 to A5. Go to Insert -Name -
Define and then delete the named range. It is that simple
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
Hi Suresh!
can you please give an example of us to solve the problem might be you can
add a example with your desired result..
Rgds
Venkatesh
On Tue, Aug 11, 2009 at 8:57 PM, suresh k brave.sur...@gmail.com wrote:
Hi All,
I have selected A1 to A5 and given some name(In Named Range).
Now
Most one knows..(Joke.)
Simply go to Insert-Name-Define.
Select the given name and click delete ( if you are using excel 2003)
OR
Go to Formulas-Name Manager.
Select the given name and click delete (if you are using excel 2007)
Regards,
Upendra Singh
+91-9910227325,