Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Used to be able to attach range of labels to xy coordinates - no m | Charts and Charting in Excel | |||
Naming variable range selected by cursor movement | Excel Programming | |||
how to test whether selected variable is within defined range | Excel Programming | |||
How dio I attach a variable to an Operator:= ? | Excel Programming | |||
How do you get a Selected Range address into a variable? | Excel Programming |