Why would you want to fill C9:C16 with the same formula?

Do you really want that value returned 8 times?

Can you add the formula in C9 manually. Then do the same with C10 and C11.

Then post those formulas.


murkaboris wrote:

Hi Dave:

The $A$3 is a unigue identified on each worksheet of the workbook. Its an
employee number based on which the date in C9:C16 is populated. The issue is
that when I run the macro as it was written it changes the cell $A$3 to a
vlookup formula that is in the "C9" cell creating a circular reference with
the run-time error.

I'm not understanding where am I supposed to change the code to:
"activesheet.range("c9:c16"). Should it replace the current
"ActiveCell.FormulaR1C1 = etc....

thanks
Monika

"murkaboris" wrote:

Hello:

I wrote a macro that recorded just fine and returned the values I needed but
when I tried to run it on the workbook and loop it for all worksheets I'm
getting the Run-time error '1004'.

Here is the excerpt from the macro:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(R3C1,'[ATF master file.xls]Orders OP'!R3C4:R55C15,2,FALSE)"
Selection.AutoFill Destination:=Range("C9:C16"), Type:=xlFillDefault
Range("C9:C16").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
With

The line starting with "Selection" and ending with Type:=xlFillDefault" is
the one causing the issue.

Any advise? I'm not too advanced with the macro's, can record simple ones
but have a bit of trouble correcting them.
Thank you.

Monika

Monika

--

Dave Peterson