Hi Again everyone;
May I please ask for some additional help.
I wish to copy data (not cell formulas) from F115:K115.
I am "trying" to use the following VB formula;
Range(Range("("f115"), Range("f115").end(xltoRight)).Copy Range ("J10")
Actually, the above VB formula copies and puts something into the 7 cells to the right of J10, but it's all gibberish.
I see that I am copying a mish-mash of cell references and so forth, and not 'just' that data (the values) which are in these cells.
Would someone please tell me how to copy 'only' the values which are in cells (F115:K115) ...
Oh yes, the values in these cells (F115: K115) keeps changing (as I want it to do) but the data does remain in these cell locations.
As always, thank you for your help.
J.
Bookmarks