VBA to copy data from 1 worksheet to another

[nancyching1711]

Hi

May I request for help (vba codes) to copy data from 1 worksheet to another:
Source: sheet1
Range: A1:IJ1000
Detination: sheet9

I tried the following (add "Module 1") but the code cannot work:

Please Login or Register  to view this content.

Thank you for your attention and assistance.

Regards
Nancy

[Sintek]

Hi Nancy

In future please view the forum rules before posting. Your post does not comply with rule #3.
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
So, do the following:
Edit your post, highlight your code and click the [#] button at the top of the post window.

[nancyching1711]

Hi

Noted and edited.

My apology.

Thank you.

Regards
Nancy

[Sintek]

Nancy, why do you say your code does not work...It tests fine

[nancyching1711]

Nancy, why do you say your code does not work...It tests fine

Hi. It show error at "Set rngSource = Worksheets("Sheet1").Range("A1:IJ100")", when I run the module. I am puzzled too.

Is there another method of copying?

Thank you for the assistance.

Regards
Nancy

[Sintek]

Please Login or Register  to view this content.

The red part is not in your code post #1

[nancyching1711]

Hi

I tried but there is an error message which shown "Run-time error 9: Subscript out of range".

This section of the code is highlighted in yellow when I run it:

Please Login or Register  to view this content.

Thank you for the assistance to resolve this error.

Regards
Nancy

[Sintek]

Time to upload sample of file...One of your sheets are not being recognized/
some object you tried to access by name cannot be found

[nancyching1711]

Sorry for the late reply as I was away. Thank you for the tips. I used excel formula to solved it. Thank you again.

[Sintek]

Glad you got it sorted. Please post your solution so others too, can learn.
Tx for rep +