|There are 3 options that come to mind:|
1 - A manual Copy-PasteSpecial operation. This would result in just the Value being copied if the "Value" option for PasteSpecial was used.
2 - A formula e.g.
--- to "copy" to a different Column on the same Sheet:
--- to "copy" to a different Sheet:
Both of these would result in a formula being in the new cell. You could then do a Copy-PasteSpecial in the new cells to remove the formulas.
3 - A macro. A macro could be used to copy just the values to the new cells. We would need more specifics before we could offer any code.
I hope something there helps.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03