View Single Post
  #1   Report Post  
Crystal
 
Posts: n/a
Default 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