Run-time error '1004' PasteSpecial

**STarloff** · 05-26-2010, 09:39 AM

The code below is being used in a spreadsheet by one of my users. I have marked the line that errors with '###.' It is intended to fill in cells on a sheet that is not filtered and does not have hidden columns. The address just before the failed line is $AH$2. AH2 is a blank cell, information should be being placed at AH3. I have no VB capabilities, but I told my user I would reach out to some VB forums for some help. If someone could help me out, you would be my hero. If there is information that is needed to debug the code, just let me know and I will get it.

Please Login or Register  to view this content.

**shg** · 05-26-2010, 09:52 AM

Does the workbook have merged cells?

**STarloff** · 05-26-2010, 10:06 AM

Negative, no merged cells in the entire workbook.

**shg** · 05-26-2010, 10:21 AM

Is the sheet unprotected?

Post a scrubbed copy of the workbook that demonstrates the problem?

**romperstomper** · 05-26-2010, 10:55 AM

I think your row insert is clearing the clipboard. Try this:

Please Login or Register  to view this content.

PS Is it really supposed to be Row - 1, rather than Row + 1 in the code to get the destination rows?

**STarloff** · 05-26-2010, 11:02 AM

@romperstomper

When I use your code, I got a different 1004 run time error, but I followed up on your postscript and changed the row - 1 to row +1 and the error is no longer generated. Some of my results are not appearing as intended, so I am in communication with my user to find out if I can privately host the workbook for examination.

**STarloff** · 05-26-2010, 11:42 AM

http://dl.dropbox.com/u/6124430/past...alworkbook.rar

This is the file in question. It is not proprietary information, so I can host it.

If you look @ the CMCSA Spread worksheet, you will see that columns B and C are percents, and column D is the sum of b+c. Everything is great until we reach row 1563 where column B is suddenly a date and thus, the yield in column D is skewed.

Additionally, you will note that every four rows is a boldfaced "...as of [date]" but at row 1565 the dates no longer increase logically.

I greatly appreciate you folks taking the time to examine this issue. Sadly, my location is under the impression that I can do VB coding, despite having made no indications of possessing that capability.