It would be helpful to post the macro (or a portion of it if it's long)
in your message. Trying to guess what you recorded is difficult...


In article ,
Matthew wrote:

Hi can anyone help,

I want to set up a macro that will give me a list of names on a sheet eg.
Matthew
Mike
David
Etc
But when I ran the macro it remembers the cell I have originally typed into
and I want it to be able run from where i place my mouse eg. It could Start
in cell C1 or D3 etc. Does anyone know the script i would need?