Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm familiar with setting an Object under UseRangeObject1() (first below)
Sub UseRangeObject1() Lr = Range("M" & Rows.Count).End(xlUp).Row Set rng = Range("M5:M" & Lr) End Sub But can't one bypass getting the Lr as Follows? Currently no working - what is wrong with syntax? Sub UseRangeObject2() Set rng = Range("M5:M" & Rows.Count.End(xlUp).Row) End Sub TIA, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object Library invalid or contains references to object defintions | Excel Programming | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Can I get a chart object (excel.ChartObject) from OLE_chart.object | Excel Programming | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming |