vba, move data only from a formula cell to a clean cell

May 1, 2012 at 17:05:18
Specs: Windows XP
Reading data through RSlinx to a 12 cell row, A10:L10 in Excel 2003. The cells contain reference links to the external data. I need to copy the received data only not the links, down 2 rows to a clean row.
Example: The RSlinx references are in A10:L10. Want to move the received data only to A12:L12.

See More: vba, move data only from a formula cell to a clean cell

Report •


#1
May 3, 2012 at 10:34:14
Have you tried:

Copy...PasteSpecial...Values

That is the standard way to copy/paste data from a cell that produced the data via a formula.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question