View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jayne22 Jayne22 is offline
external usenet poster
 
Posts: 20
Default vba: attach a variable name to a selected range

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