Thread: PasteSpecial: values and formats possible in vbs?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
y sakuda y sakuda is offline
external usenet poster
  
Posts: 3
Default PasteSpecial: values and formats possible in vbs?
"D. Pirate Roberts" wrote in message
...
I use the following code in vbs to copy and paste data from one Excel cell
to another:

XLBook.Worksheets("Sheet1").Select
XLBook.Worksheets("Sheet1").Range("A1").Copy
XLBook.Worksheets("Sheet1").Range("B1").PasteSpeci al

Hellow
Try this

XLBook.Worksheets("Sheet1").Range("B1").PasteSpeci al -4122

Note: for -4122 search for Object browser with xlpasteformats
Y Sakuda from JPN


Reply With QuoteReply With Quote