1004 Error Setting Variable Equal to Value of a Range

[stinkingcedar]

Hey guys,

So I keep getting a 1004 on this particular line of code

newVal = sht.Range(Cells(4 + (30 * i), j)).Value

Sht is a worksheet variable set to one specific sheet in the workbook, newVal has been declared as double, i and j have both been declared as integers. Keeps telling me the range method failed.

 

[JLGWhiz]

Is there a value in cell E4 of shtD? If so, what is it?

 

[JLGWhiz]

Does this work?

newVal = sht.Cells(4 + (30 * i), j).Value

Maybe

newVal = shtD.Cells(4 + (30*i), j).Value

 

[Norie]

Oops, I was just looking at the code in the first post.

 

[JLGWhiz]

Oops, I was just looking at the code in the first post.

Don't know why I didn't see it right away. I normally spot those right off. A lot people make the mistake of using Range to precede a Cells desination. That should fix the problem for the OP.

 

[Rick Rothstein]

Don't know why I didn't see it right away. I normally spot those right off. A lot people make the mistake of using Range to precede a Cells desination. That should fix the problem for the OP.

I missed it too.

 

[Joe4]

I missed it too.

Me three!