loop Statement
 

I have calculated a data using a formula and I need the code to loop thru the
sheet running the formula thru a column. Autofill does not work because it
will give me Jan-1 Jan-2 etc,

In column A I have a value DJAN-1 DJan-2 Djan-4 etc this formula will work
correctly to give me the data


Sheets!graphdata.Range("r4") = (dwmonth & "-" &
Mid(Sheets!graphdata.Range("A4"), 6, 2))

in R5 I want it to look in cell A5 to get the value and then insert it

There are 343 rows it has to loop thru putting the value in A? in R?

what is the quickest and easiest way of doing this

Thanks