Runtime error for macro that works in workbook created in
Hi there,
I created a macro to fill in fields and saved it in my personal workbook so
it could be used for all my workbooks. It works in the original workbook I
created it in, but when I try to open it in others, I get the 1004 runtime
error!
Is there something I'm doing wrong? All my fields are named, and when I run
it, it fills in the first field but gives me the error immediatly after.
Here's my code, hopefully someone can offer me help.
Thanks!
Crystal
Sub Macro1()
'
' FormFill Macro
'
Range("REQUESTORF").Select
ActiveCell.FormulaR1C1 = "Crystal"
Range("REQUESTORL").Select
ActiveCell.FormulaR1C1 = "Nassouri"
Range("ADDRESS").Select
ActiveCell.FormulaR1C1 = "Oakway"
Range("E2").Select
End Sub
|