vba: attach a variable name to a selected range

[Jayne22]

I would like to attach a variable name to a range. Is this possible? And if
so, what do I 'Dim' this variable as (string, integer, etc)?

I need to reuse the range when I run a macro which places a formula into a
cell. I want the macro to place a dsum formula into a cell, but since the
range will always be changing, I need to attach a variable to it.

This does not work:

Dim work_items as String
Sheets("work items").Select
work_items = Range("a1:z6000").Value

 

[Joel]

set work_items = Sheets("work items").Range("a1:z6000").Value

 

[ward376]

You might try using a variable named range - check out Contextures:
http://www.contextures.com/xlNames02.html

Cliff Edwards

 

[Jayne22]

awesome! thanks for the help!

 

[Don Guillett]

Sheets("work items").Range("a1:z6000").name="Whatevernameyoulike"