Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special
Hii All
The following code works fine: range("F12").Copy range("F13:F" & lrow - 1).PasteSpecial (xlPasteFormats) I tried to reduce it to the following and it gives an App error: range("F12").Copy range("F13:F" & lrow - 1).PasteSpecial(xlPasteFormats) It seems to be quite happy to accept the line of code when I type it in. Where is it wrong ?? Any advice is appreciated Regards Michael M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
How do I capture user paste action and convert to Paste Special | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |