| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a Variable to a Macro
I want to create a simple Macro that sorts a list by the criteria that a user
enters. I know I would hard code this macro with something liek: ActiveSheet.Range("$A$5:$CW$355").AutoFilter Field:=77, Criteria1:="0008" but I want the user to be prompted to select the Criteria, "0008" in this instance, and then have the list sort. I am hoping it is pretty easy... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing variable to Access | Excel Programming | |||
| Passing variable to VarType of other Variable | Excel Programming | |||
| Passing variable from one sub to another | Excel Programming | |||
| Passing a value to a variable from Userform | Excel Programming | |||
| Question: Macro overloading, passing variable number of arguments | Excel Programming | |||
Threaded Mode
