Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anybody tell me why variable g is causing an error when it gets to
order1:=g? Why wouldn't d be causing the same error? Thanks! d = InputBox("What cell do you want to sort by on this page?", Xpos:=9000, Ypos:=7000) g = InputBox("How do you want to sort? Please answer either" & Chr(13) & _ "with xlAscending or xlDescending", Xpos:=9000, Ypos:=7000) If d = "" Then GoTo Option1 End If On Error GoTo Option2 ActiveSheet.Range(a, c).EntireRow.Select Selection.Sort Key1:=Range(d), order1:=g |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions | |||
label problem | Excel Worksheet Functions |