Paste formula only .....dont want text

**DonkeyOte** · 06-07-2010, 02:56 PM

It's not really weird - it's standard functionality.

As outlined - if a cell contains only a Constant (ie manually entered value) this is seen as the "formula value" by XL
(though yes, HasFormula will return False as it's a Constant in the same way as SpecialCells would also see it as a Constant).

**welchs101** · 06-07-2010, 03:01 PM

ok...thanks. So i guess its not weird. But what would you suggest i do now? thanks.

**DonkeyOte** · 06-07-2010, 03:03 PM

Originally Posted by welchs101

But what would you suggest i do now?

Well if the cell contains only a Constant and you don't want to copy the content of the cell this raises the question of why are you copying it in the first instance ?

If as presumed you wish to copy the cells formatting or validation rules then I would suggest you copy paste special as appropriate.

**welchs101** · 06-07-2010, 03:14 PM

I guess i am not communicating very well.

I am copying an entire row. I just used the single cell as a talking point.

I am copying a row and want to paste the "formatting" of that row. However, if there are any constants in that row then they also get pasted.....and i dont want that.

does this make sense.