Excel will not paste clipboard material using VBA

[grazian2]

Hello,

Currently, I have some code that takes data from a user selected excel workbook and imports it into a master data list (where the macro is run from)

My code, listed below, does not allow me to paste the copied material into the cell I indicate. I have been searching the internet and attempting many different methods. I am hoping someone can assist me with my problem. The code that is highlighted in debugger mode is ActiveSheet.Paste (bolded below)

Thank you in advance.

Best regards,

Grazian2


Code

Please Login or Register  to view this content.

[Solus Rankin]

grazian,

Please use code tags in your post.

Click edit post, highlight your code, click # button in toolbar.

[Solus Rankin]

Try:

Please Login or Register  to view this content.

Instead of:

Please Login or Register  to view this content.

[grazian2]

XeRo,

I will be sure to use code tags in the future, my apologies.

Unfortunately, I am still receiving a runtime error 1004.

If I manually copy and paste the information, it pastes perfectly fine into the cell.


Thanks,

Grazian2

[Solus Rankin]

I haven't been able to test any of it because I don't have your Workbooks but why are you deleting the row you've just pasted?

Please Login or Register  to view this content.

[Solus Rankin]

In which module is your code saved?

[grazian2]

I am pasting approximately 300 rows into the new file. The top row in the copied material contains column titles, which are already include in the workbook the material is being pasted into. Thus, I delete them.

My code is saved in Module2

Thanks!

[JosephP]

you're copying entire columns which you can only therefore paste into row 1. replace

Please Login or Register  to view this content.

by

Please Login or Register  to view this content.

[grazian2]

Joseph P,

That worked great!

Thank you very much for your assistance.