| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting in a macro and defining last row into varible not working in
Dim LastRow99 As Long
LastRow99 = .Cells(.Rows.Count, "A").End(xlUp).Row ActiveWorkbook.Worksheets("Working Sheet").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Working Sheet").Sort.SortFields.Add Key:=Range( _ LastRow99), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal I get Run-time error '1004': Method 'Range' of object '_Global' failed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defining cells that macro will change | Excel Worksheet Functions | |||
| defining names in a macro | Excel Discussion (Misc queries) | |||
| Macro or VBA process varible row data | Excel Programming | |||
| Macro that sums cells in rows of varible number and.... | Excel Programming | |||
| How to approach defining where macro looks? | Excel Programming | |||
Threaded Mode
