Macro from Excel 2003 not working in 2007

[konik]

Hello,

could you please someone help me with this macro?

It is working great in Excel 2003, but generated error in 2007: runtime error 1004 paste method of worksheet class failed with highlighted line Activesheet.paste (red marked).

Please Login or Register  to view this content.

Any ideas, what can be wrong?

Konik

[royUK]

What's activerow?

[konik]

Hi,

I would say active row is specified at the beginning, but I am not an author of this macro.

This macro is just adding 2 text boxes under last active rows + 3 rows.

Number of rows is always different.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[konik]

This is good idea. I attached 2 files:

system output is extraction of our system, then we apply macro test and get result (both in Result in Excel 2003).

Konik

[royUK]

Using the Result workbook I deleted the boxes then ran the code in Excel 2010 with no problem.

No error in the other workbook either

[konik]

Hi Roy,

these boxes should be there. I still have hard time to understand, why it can work completely in 2003 and fail in 2007? I found some article on Microsoft help site saying, that there are no major changes between these 2 versions concerning VBA.

I am still getting errors, see attached pictures.

Is there any workaround, how to make it work on both versions?

[konik]

Better solution how to enter 2 text boxes for signatures under last active row +3 is also welcome.

[royUK]

Why not just merge cells to look like a TextBox?

[konik]

Hi Roy,

this would be OK, but how could I do it, when there is always different number of rows?

[jaslake]

Hi konik
I've taken the liberty of cleaning up the code a bit. It's been tested in both Excel 2000 and Excel 2007. See if this fixes your issue.

[konik]

Attachment 164956 Hi Jaslake,

I am sorry for very late answer. I tested it at work and it didn't work correctly. First text box is moved up, but second one is correct, see att. picture. What could be wrong? konik