VBA code delete row (where am I going wrong) please help

[Ram_1967]

Hi to everyone,

(New member)

A very Novice/beginner with using VBA, I created this small routine, I thought it was working but then after using the routine a few times it stops with the following error code;

'run time error 2147417848(80010108)'
Method 'Insert' Object 'Range' failed


I know I have made a huge mistake somewhere along the line, and I've spent quite a few days trying to get it to work but now grinded to a halt, so I'm hoping someone could possibly help me in correcting my mistake?

Idea is this, cut the ranged row ("C1:U1") from active sheet and paste it into the next available row in the sheet called "TO BE CLOSED", It works for a few times say 8,9 or 10 times then suddenly stops and reports the error!

Huge thanks in advance, code as follows;

Please Login or Register  to view this content.

again thanks in advanced its really appreciated.

[Trebor76]

Hi Ram_1967,

Welcome to the forum!!

Without seeing the workbook it's hard to diagnose (there be an image or something in one of the cells??) but let me know how this goes:

Please Login or Register  to view this content.

Regards,

Robert

[beyond Excel]

Hello. You can try with:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

the one you like best.

[jolivanes]

What do you get when you run this?

Please Login or Register  to view this content.

[mjr veverka]

... cut the ranged row ("C1:U1") from active sheet and paste it into the next available row in the sheet called "TO BE CLOSED" ...

1. Do these activities take place within one workbook ?
2. What is the name of the worksheet with range "C1:U1" and are there merged cells in this worksheet ?
3. Is there maybe a rows overflow in the sheet "TO BE CLOSED" ? (worksheet has 1048576 rows only)
4. In the content you write about "the next available row", but in the code you have something else (you insert "the next row" in the place of cell "A2") ?

[Ram_1967]

Hi to all, and thanks for all the replies, I have attached a simple workbook with examples for better explanation, again thanks to all for your help it is very much appreciated.

[jolivanes]

But we never got an answer on Post #4 which should be used on the original workbook.

[beyond Excel]

I have attached a simple workbook with examples for better explanation...

Let's go again:
a) Select any cell in the row to move.
b) Run the macro.
c) Check the result.

Please Login or Register  to view this content.

[Ram_1967]

Awsome thanks 'Beyond Excel' That last code worked and thanks to everyone else who replied, I forgot to mention in my last post that I tried them all and they didnt work exactly they way I wanted it to, but Beyond Excel last code worked perfectly, again thanks for your time its very much appreciated.indeed.

[beyond Excel]

Awsome thanks 'Beyond Excel' That last code worked and thanks to everyone else who replied, I forgot to mention in my last post that I tried them all and they didnt work exactly they way I wanted it to, but Beyond Excel last code worked perfectly, again thanks for your time its very much appreciated.indeed.

Luckily we reached the finish line because the options were running out, hahaha