copy down formular from the row above

[coolwater]

Hi Everybody,

I need to copy down the formular from column C&D from the row above, every row is one week, so the last row is week 52.
The code I have it copy the exact formular from the cell, it is not copy DOWN the formular.

Any help will be appreciate it.

Thanks.

Please Login or Register  to view this content.

[MarvinP]

Hi coolwater,

It looks like your are copying the .Value into m_copy instead of everything about the cell.

Try changing two lines
Change Dim m_copy As String to Dim m_copy As Range
Then change m_copy = Range("M1").Value to m_copy = Range("M1")

I'd need more code or a sample of the workbook to suggest more.

[coolwater]

Hi MarvinP, Thanks for your reply. I can't upload a file.

So here is an example, hope it can explain better.
the week number is in column A,2011 in column B,2012 column C ( B&C) are the ones I need to copy down the formular.
The C6 is in cell "M1"



2011 2012 week on week Cell update to C6
week1 200 100
week2 200 200 100%
week3 200 300 50%
week4 200 400 33%
week5 200 520 30%
week6 200
week7 200
week8 200
week9 200
week10 200
week11 200
week12 200
week13 200
week14 200

[MarvinP]

Hi coolwater,

To attach a file, click on the Go Advanced below the normal message area and then on the Paper Clip Icon above the advanced message area. This will open a dialog that allows you to select a file and upload it to this site.

[coolwater]

I saw that function, it's work computer security reason,I can't upload files to the web site.

[MarvinP]

Is there a reason you need to do this using VBA instead of simply dragging it down a cell?

[OnErrorGoto0]

If you just want to copy the formula, I would suggest

Please Login or Register  to view this content.

[coolwater]

Hi OEGO, I used your code and it works, however it is only copy the formular in column C, What should I change to get formular copy down for Column D as well.

what's the "R1C1" mean?
Thanks for your help.

Regards

[OnErrorGoto0]

It is unclear from your code, but possibly

Please Login or Register  to view this content.

R1C1 is the reference style (as opposed to A1).