Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy named range contents to activecell position
Hi
I have a dynamic named range "Shift1". I would appreciate some code that I can assign to a button that will copy the contents of the named range to the active cell position. TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy named range contents to activecell position
Neal,
Named ranges can be available to the entire workbook or they can be worksheet specific. If the name is at the workbook level: Sub Shift1() ActiveCell.Value = Range("rngShift1").Value End Sub If it is worksheet specific, this is prefered: Sub Shift1() ActiveCell.Value = Worksheets("Sheet 1").Range("rngShift1").Value End Sub Dale Preuss "Neal" wrote: Hi I have a dynamic named range "Shift1". I would appreciate some code that I can assign to a button that will copy the contents of the named range to the active cell position. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy named range contents to activecell position
Private Sub CommandButton1_Click()
Range("Shift1").copy Destination:=ActiveCell End Sub -- Regards, Tom Ogilvy "Neal" wrote in message ... Hi I have a dynamic named range "Shift1". I would appreciate some code that I can assign to a button that will copy the contents of the named range to the active cell position. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy contents of a named range to a section on working area | Excel Discussion (Misc queries) | |||
Finding if the activecell is withing a named range | Excel Programming | |||
How to get the position of a cell in Excel named range? | Excel Programming | |||
How to get the position of a cell in Excel named range? | Excel Programming | |||
How to get the position of a cell in Excel named range? | Excel Programming |