Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba: attach a variable name to a selected range
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba: attach a variable name to a selected range
You might try using a variable named range - check out Contextures:
http://www.contextures.com/xlNames02.html Cliff Edwards |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba: attach a variable name to a selected range
awesome! thanks for the help!
"ward376" wrote: You might try using a variable named range - check out Contextures: http://www.contextures.com/xlNames02.html Cliff Edwards |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
attach a variable name to a selected range
Sheets("work items").Range("a1:z6000").name="Whatevernameyoulik e"
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jayne22" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |