Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to select a defined range
Thanks in advance to all who help on this site.
I have the below code: Public Sub MMR() ' Keyboard Shortcut: Ctrl+x Dim DataSD As Worksheet Dim MMR As Range Set MMR = DataSD.Range("MMRrange") MMR.Select End Sub When I Set MMR to = DataSD.Range("MMRrange") the MMRrange refers to a defined range of cells on the DataSD worksheet. However, I have something wrong for when I run this program this line gives an error? -- Thanks Shawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I see defined name range? | Excel Discussion (Misc queries) | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
Defined name range | Excel Programming | |||
Defined name range | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |