Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Create named range

Hi,
I would like to know, how to define named range in excel by programmatically
with Visual Studio 2005 Tools for the Microsoft Office System

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Create named range

Application.ThisWorkBook.Names.Add(.....);
Have a look at VBA Help files and the parameters for the method.

If you are using C# use Type.Missing for optional variables

"Matee" wrote:

Hi,
I would like to know, how to define named range in excel by programmatically
with Visual Studio 2005 Tools for the Microsoft Office System

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a dynamic named range? Sunita Excel Discussion (Misc queries) 3 March 28th 08 07:47 PM
Using a formula to create named range reference [email protected] Excel Worksheet Functions 4 June 29th 05 08:03 PM
create named range in each sheet in workbook davegb Excel Programming 3 March 29th 05 07:47 PM
Create a Named Range in Excel with VBA GoKingBee Excel Programming 2 December 7th 04 08:13 PM
Create named range Robert[_16_] Excel Programming 2 October 27th 03 11:57 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"