I have a simple macro to copy/paste rows into a worksheet. The user clicks a button to add additional rows. If I click it the first time, it works. If I click it the second time, I get this message: "Rutntime 1004: Unable to get the pastespecial quality of the worksheet class". Any help would be much appreciated...thanks!
Please Login or Register to view this content.
Last edited by Leith Ross; 06-11-2013 at 03:41 PM. Reason: Added Code Tags
why would you want to do that?, the pastespecial pastes the copied cells, not just the values, even if you are only pasting the values. it's not as if they become variables that can be calculated. it looks like you want to paste the value then the value - 4122
for that you would have to do something different
is ToCopy a single cell or a range of cells?
for a cell named ToCopy:
Please Login or Register to view this content.
ToCopy is a range of cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks