Copying excel Data to new worksheet Error 1004

Question

I am trying to copy certain information from cells into another spread sheet. I have a For loop which loops through the rows. The program bugs out when I try to copy the cells into the new spread sheet. Should I be using range ? And do I need to say the worksheet before cells ?

This is just a sample of the code :

Set myOtherSheet = ThisWorkbook.Sheets("Sheet2")
For Each WkSht In ThisWorkbook.Worksheets
If WkSht.Name = "Sheet1" Then
j = 0
For r = 6 To 1000

myOtherSheet.Cells(j, 1).Value = WkSht.Cells(r, 2)
myOtherSheet.Cells(j, 2).Value = Match

There Error I get is a 1004 object defined error

matzone matzone · Accepted Answer · 2013-07-12T07:54:01

2

votes

Might caused by j = 0 .. there's no rows 0 .. at least it should be ..

j = 1

Copying excel Data to new worksheet Error 1004

1 Answers