About Us

Don Guillett

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"clara" wrote in message
...
Hi Don,

Thank you for your help

Clara
--
thank you so much for your help

"Don Guillett" wrote:

Sheets("Tasks").Range("A2:A500").name="usethis"

for each t in [usethis]
'blah
next t

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"clara" wrote in message
...
Hi all,

the following is my current code:
For Each t In Sheets("Tasks").Range("A2:A500")

I'd like to define a name refer to ("A2:A500") and use that name in the
above code, how can I do it.

Clara
--
thank you so much for your help

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Refer to value	strikeuk	Excel Discussion (Misc queries)	8	May 17th 06 08:42 AM
refer to columns	Cindy	Excel Discussion (Misc queries)	1	January 20th 06 09:51 PM
refer	JE McGimpsey	Excel Discussion (Misc queries)	2	November 28th 05 06:55 PM
How to refer to every 5 th cell?	R.P.McMurphy	Excel Discussion (Misc queries)	21	August 27th 05 06:13 PM
refer to other xls file	DKY	Excel Worksheet Functions	1	November 19th 04 08:02 PM