Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro output location
I'm running a macro (using a command button) that creates a validation list,
however depending on where the button is the output ends up in different places. How can I assign a cell to the output so it always goes in the same place? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro output location
Would help if you post the code. You can specify a specific sheet and range
using, e.g., Worksheets("Sheet1").Range("A1") but how to use that within your macro depends on the actual code, so please post a copy. -- - K Dales "Ribeye" wrote: I'm running a macro (using a command button) that creates a validation list, however depending on where the button is the output ends up in different places. How can I assign a cell to the output so it always goes in the same place? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro output location
'
Here is the code I am using: Keyboard Shortcut: Ctrl+q ' Sheets("Sheet1").Range("A2:A15337").AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range("A1"), Unique:=True With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=$A$2:$A$93" .IgnoreBlank = True .InCellDropdown = True .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True End With ActiveWindow.SmallScroll Down:=-51 End Sub (Thanks in advance) "K Dales" wrote: Would help if you post the code. You can specify a specific sheet and range using, e.g., Worksheets("Sheet1").Range("A1") but how to use that within your macro depends on the actual code, so please post a copy. -- - K Dales "Ribeye" wrote: I'm running a macro (using a command button) that creates a validation list, however depending on where the button is the output ends up in different places. How can I assign a cell to the output so it always goes in the same place? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
macro output location | Excel Programming | |||
output macro | Excel Programming | |||
Help on macro output | Excel Programming | |||
Need help with report output....macro??? | Excel Programming |