Apply formula to all cells in column C for all populated cell in column A

I have a changing number of cells in column A and I need to have column C values equal a formula that uses the values in column A. So for every value in column A there will be a value in column C. I need to write this in vba and have it assigned to a macro button. I also need it to create a pivot table graph in another worksheet. Here is what I have so far:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

That is able to put values into cells in column C but they are not correct. They should show up at dates mm/dd/yyyy but instead I am getting numbers like this: 41782. The date for this example is: 5/23/14 12:19:05:439 EDT. Thank you

Hi, I think the values are probably correct but you need to change the format of column C to display them as dates. for example,

Please Login or Register  to view this content.

I get a runtime error that say error 483.

Sorry, I misspelt numberformat

Works perfectly, Thank you. I should've seen that... Too much just blindly copying and pasting without reviewing!

Change this: .Numberfomat = "dd/mm/yyyy"

To this: .Numberformat = "dd/mm/yyyy"