Expression to Create a Range Name

Gerry

Guest

Posts: n/a

11th May 2004

Can I use an expression to create a Range Name. If I have
a sheet with 10 rows which can sometimes vary, with cols
from A to C always. All rows will always have information
(i.e no blanks) can I create a range name in a Macro like
Range("B:COUNTA(B:B)")

« Complicated (well to me it is!) | Counting instances that are not near each other »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change first name last name to last name first name	Doris smith	Microsoft Excel Misc	3	25th Feb 2009 12:35 PM
Apply Name (Define Name, Name Range)	=?Utf-8?B?S2FyaW4=?=	Microsoft Excel Misc	2	3rd May 2007 01:06 PM
how do I reveerse name order last name, first name to first name, last name	Don Smith	Microsoft Excel Discussion	9	29th Nov 2006 10:55 PM
Name range within a name range	=?Utf-8?B?dHJhdmlz?=	Microsoft Excel Discussion	2	10th Nov 2006 03:37 PM
Changing a list from last name, first name to first name, last name	zgall1	Microsoft Excel Misc	3	17th Feb 2006 12:49 AM