| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to refer a name in VBA
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to refer a name in VBA
Dim S as String S="A2:A500" and then use: Range(S) you can accomplish the same thing by using a Defined Name from the worksheet. -- 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to refer a name in VBA
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to refer a name in VBA
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refer to value | Excel Discussion (Misc queries) | |||
| refer to columns | Excel Discussion (Misc queries) | |||
| refer | Excel Discussion (Misc queries) | |||
| How to refer to every 5 th cell? | Excel Discussion (Misc queries) | |||
| refer to other xls file | Excel Worksheet Functions | |||
Hybrid Mode
