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?