Macro to replace ? with the actual row number

[Chmeee]

Hi, I am hoping someone can help me with this
Each week I use a macro to open a Sales spreadsheet that was exported from MSaccess and copy it to my report
However, the freight formula in each row of the spreadsheet is incorrect as it does not show the row numbers
The formula shows as =ROUND(k?*0.01560, 2). Where the “?” should be the row number. Column K contains the various Qtys and the .01560 is the cents per litre.
Is there any way to have the macro change this to the relevant row numbers without having to go down the column selecting each row?

 

[Marcelo Branco]

Assuming the formulas are in the Range ("A2:A20") maybe something like

Try it on a copy of your workbook

Dim rCell As Range

For Each rCell In Range("A2:A20")
    rCell.Formula = Replace(rCell.Formula, "K?", "K" & rCell.Row, compare:=vbTextCompare)
Next rCell

M.

 

[Chmeee]

Thanks Marcelo, Works perfectly
It was that quick it was finished before I looked back up from my watch
Will save me lots of time
Thanks again

 

[Marcelo Branco]

Thanks Marcelo, Works perfectly
It was that quick it was finished before I looked back up from my watch
Will save me lots of time
Thanks again

You are welcome and thanks for the feedback

M.