Copying results of a formula across

[brendan2711]

Hey guys.

I've been working on a spreadsheet and have gotten stuck
I am trying to make it so that I can run a macro and it will take what is returned by the formula in column K, and place that number in column B, without screwing up the formula that is there, just copy paste the result.

Any help appreciated.
Thanks

[6StringJazzer]

The following line of code will copy the result of a formula in column K to the same row in column B, where r is a variable with the row number.

Cells(r, "B") = Cells(r, "K").Value

How do you determine what row you want to perform this on? Or do you want to do the entire column?

I really don't understand what you mean by "without screwing up the formula that is there, just copy paste the result." Copying from K certainly won't have any effect on the formula there, and if you mean B, you can't paste a value into a cell without replacing any formula that might exist there.

[brendan2711]

I am wanting it to do every row except row 1. So like 2-1000 would be ideal.
I am not real experienced with the whole macros thing so takes me a while to do the basic stuff.