| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
