| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Paste to PasteSpecial Values
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I catch a Paste action and default it to PasteSpecial-Values | Excel Programming | |||
| PasteSpecial Paste:= xlPasteFormats problem | Excel Programming | |||
| Paste vs PasteSpecial | Excel Programming | |||
| paste negative time with PasteSpecial | Excel Programming | |||
| PasteSpecial Paste:=ColumnWidths | Excel Programming | |||
Threaded Mode
