I have the following piece of code that needs a minor adjustment! the PasteSpecial needs to go into the row that I just inserted not into the Range("InsertHere"
. How can I do that?
Thanks for any help!
leslie
Sub Copy_Formulas() 'copies each Interviewer name to formulas,
'then copies the result of the formulas to the Monthly report.
For Each c In Range("Interviewers"
c.Copy ("int_name"
Range("frms"
.Copy
Range("inserthere"
.Insert shift:=xlDown
Range("inserthere"
.PasteSpecial ([Paste:= xlPasteValues])
Next
Range("inserthere"
.Delete shift:=xlUp
Worksheets("MonthlyReport"
.Select
End Sub

Thanks for any help!
leslie
Sub Copy_Formulas() 'copies each Interviewer name to formulas,
'then copies the result of the formulas to the Monthly report.
For Each c In Range("Interviewers"

c.Copy ("int_name"

Range("frms"

Range("inserthere"

Range("inserthere"

Next
Range("inserthere"

Worksheets("MonthlyReport"

End Sub