Hi Gary,
thank you for your help
--
thank you so much for your help


"Gary''s Student" wrote:

Dim clara as String
clara="A2:A500"
For Each t In Sheets("Tasks").Range(clara)
--
Gary''s Student - gsnu200793


"clara" wrote:

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