visual basic
Here is a sample of the macro
'
ActiveCell.FormulaR1C1 = "Matthew"
Range("R2").Select
ActiveCell.FormulaR1C1 = "Mike"
Range("R3").Select
ActiveCell.FormulaR1C1 = "David"
Range("R4").Select
End Sub
"JE McGimpsey" wrote:
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?
|