View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fernando fernando is offline
external usenet poster
 
Posts: 9
Default xlPasteValuesAndNumberFormats

Hello,

I am pasting data with a macro using
xlPasteValuesAndNumberFormats. In computers that have
excel 2000, this constant is not recognized. I looked it
up in the "object examinator"(F2), and it is part of the
class XlPasteType. However, in excel 2000 this class
doesn't have the xlPasteValuesAndNumberFormats constant.
Is there a way to add this constant without having to
install a newer version of excel?

Thanks for your help
Fernando E