Insert shift down issue macro issue

[CC64]

Hi,

Could someone please give me some guidance with an issue I am having.

I'm trying to copy a range of data from one sheet, paste it to another, then insert and shift down one row.

The first example below works but if I'm working on another sheet it will always returns me to sheet two.

The second example I think is heading in the right direction(minus .Activate and .Select) but I don't how to incorporate the insert and shift down without encountering the issues of the first example.

Any help would be appreciated.

Thanks,

Simon

Please Login or Register  to view this content.

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[CC64]

Hi TMS,

Thanks for your reply.

I ran your code but received a run time 'error 438 object doesn't support property or method' on the following line.

Thanks

Simon

Please Login or Register  to view this content.

[TMS]

Oops:

Please Login or Register  to view this content.

Regards, TMS

[CC64]

Thanks again for your help TMS.

For some reason a compile error was triggered in the StartTimer macro.

I changed the name of the procedure which seemed to fixed the problem???

It's working so that's all that matters.

Cheers,

Simon

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save