Quote 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.