Name Issue

[clara]

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

 

[Gary''s Student]

Dim clara as String
clara="A2:A500"
For Each t In Sheets("Tasks").Range(clara)

 

[JLGWhiz]

Here is one way:

Sub fh()
Sheets(1).Range("B2:B5").Name = "SomeName"
End Sub

You can also just use a variable for code purposes:

SomeName = Range("B2:B5")

The difference is that when you use the range name as the object it would be
Range("SomeName") and is a range object. The other would be a variable that
could be used as a value - SomeName - or a range - SomeName.Address and a few
other variations depending on your declarations.

 

[clara]

Hi JLGWhiz

thank you for your help

Clara

 

[clara]

Hi Gary,
thank you for your help