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


"Jayne22" wrote:

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