Copy and Paste

[rizmomin]

Hello:

I have excel workbook with data in different sheet.
I need to copy and paste (Values and Source Formatting) data from cell range A1:K100 in "Summary" Sheet to "Sheet1" at Cell A10.

Please help with this simple VB code.

Thanks.

Riz

[AB33]

Riz,
If it is just a single range(With out looping), try this one

Please Login or Register  to view this content.

[rizmomin]

Hi AB33:

Superb, you are great helper.
I use Excel a lot but don't know VB Coding and people like you on this forum helps me out a lot.
Love it...Once again thank you and you may be seeing more threads from my end now and then.

Looking forward for your help in future.

Riz

[AB33]

You are welcome!
PS:I am, like you, is still on the learning curve.