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 Works
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 wrote:
> Hi All,
>
> I have selected A1 to A5 and given some name(In Named Range).
>
> Now I want to remove
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, +91-9
