VB Code to cut and paste

[rizmomin]

Hello:

Please refer to attached file.
I need VB Code to cut and paste the range A3:H (to the last row) from "Source" Sheet to the last available
row column A in Sheet "Inv_Sum").
In attached example i would need to cut A3:H249 and paste at "Inv_Sum" sheet at A1846

Let me know if you have any questions.
Thanks.

Riz

[Trebor76]

Hi rizmomin,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[rizmomin]

Hi Trebor76:

Works except small modification.
Need Cut and paste instead of Copy and Paste.
Please let me know if you have any questions.
Thanks.

Riz

[Trebor76]

Simply change .Copy to .Cut

[rizmomin]

Hi Trebor76:

That would work...Thanks a lot

Riz

[Trebor76]

You're welcome

If you could mark the thread as solved it would be appreciated

Thanks,

Robert