Size and shape of data in clip board conflict with paste/special area4

[Bob1980]

Hi All,

I'm looking for the right way to handle this error that I'm receiving. Actually, it's an error; but most likely due to my faulty code. This is what I'm looking to do. There's an area in my spreadsheet that I want people to paste data into. This area has special formatting, so I'm replacing the ctrl+v and adding a paste button, to do a special paste into that area. Unfortunately, the amount of data that is copied and pasted varies; so when the code attempts to paste/special the values into the area, I get a "Data on the Clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway" message. I don't want this message, but I know it has to do with the method in which I'm pasting the data.

below is my code:

Please Login or Register  to view this content.

The error is occurring after the ".PasteSpecial xlPasteValues"

This sheet dimensions of the area is 36 Rows X 3 Columns. but, the amount of data pasted into the area can vary by the row amounts, but is always consistent in terms of the columns.

I thought that I could check the content/dimensions of the data inside of the clipboard and then use those dimensions to map to the appropriate area size, this will also allow me to check the data in the clipboard.

but, if there's another workaround, and a more "correct" way of doing this; I would be much obliged to hearing the remedy.

Thanks,
Bob1980

[Bob1980]

Nevermind! LOL,

I just changed the range of cells that is being pasted into, to the upper left corner "cells(4,3)" as opposed to the whole range. I guess excel at this point is use to this type of selection, so it err handles itself. Below is the update:

Please Login or Register  to view this content.

Thanks a bunch to everyone still, I wouldn't have been able to get to this point if it weren't for this community.

Thanks,
Bob

[Bob1980]

Nevermind! LOL,

I just changed the range of cells that is being pasted into, to the upper left corner "cells(4,3)" as opposed to the whole range. I guess excel at this point is use to this type of selection, so it err handles itself. Below is the update:

Please Login or Register  to view this content.

Thanks a bunch to everyone still, I wouldn't have been able to get to this point if it weren't for this community.

Thanks,
Bob