About Us

papou[_2_]

My pleasure!

Cordially
Pascal

"Bob" a écrit dans le message de news:
...
Pascal,
That did the trick! Thanks!
Bob

"papou" wrote:

Hello Bob

Worksheets(Sheet1Name).Cells(Sheet1EmpTypeRowPoint er, h).Copy

Worksheets(Sheet2Name).Cells(Sheet2RowPointer, _
Sheet2EmpTypeColPointer).PasteSpecial (xlPasteValues)

HTH
Cordially
Pascal

"Bob" a écrit dans le message de news:
...
Con someone kindly tell me how to modify the line of code below so that
instead of copying the contents, formatting, validation, etc. of a
cell,
it
simply copies the cell's value?

Worksheets(Sheet1Name).Cells(Sheet1EmpTypeRowPoint er, h). _
Copy Worksheets(Sheet2Name).Cells(Sheet2RowPointer, _
Sheet2EmpTypeColPointer)

Thanks in advance for the help.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I catch a Paste action and default it to PasteSpecial-Values	srinu1264[_9_]	Excel Programming	8	May 23rd 06 02:15 PM
PasteSpecial Paste:= xlPasteFormats problem	Ken Johnson	Excel Programming	4	March 21st 06 11:25 AM
Paste vs PasteSpecial	Gary''s Student	Excel Programming	3	February 25th 06 06:29 PM
paste negative time with PasteSpecial	Sylvian	Excel Programming	20	September 2nd 05 06:03 AM
PasteSpecial Paste:=ColumnWidths	Arvi Laanemets	Excel Programming	3	February 8th 05 01:46 PM