Runtime error 1004 - Application Defined or Object Defined error

**andreroux** · 06-06-2013, 10:13 AM

I have a macro, that worked before I put in a For...Next Statement. Now I get an error which did not happen before the changes. The error reads: Runtime error 1004 - Application Defined or Object Defined error.

The line on which I get the error is as follows: ActiveSheet.Range("J" & ROW_NO).Select and I cannot figure out why. The ROW_NO is defined as Dim ROW_NO As Long and is initialised as follows:ROW_NO = 2

For the sake of completeness, I supply the entire code below:

Please Login or Register  to view this content.

**AB33** · 06-06-2013, 10:28 AM

Andre,
Please use code tags with your code. The code has almost filled-up the entire page.

**andreroux** · 06-06-2013, 10:33 AM

HI AB33

Sorry about that. Only figured out now how to do it. Big OOPS on my side.

Thanx for helping me right

Andre

**Norie** · 06-06-2013, 10:34 AM

When you get the error ROW_NO has no value.

**andreroux** · 06-06-2013, 10:43 AM

Hi Norie

I see what U r saying. But at the beginning of the macro, I do give ROW_NO a value of 7 with the line: ROW_NO = 7. Maybe U are seeing something that I am missing. I am, after all, a novice with VBA

Regards

Andre

**Norie** · 06-06-2013, 10:46 AM

Andre

You've declared and given ROW_NO a value in the first sub (Macro1), it's not recognised in the second sub (DoWork).

**andreroux** · 06-06-2013, 10:56 AM

Hi Norie,

THanx for pointing me in the right direction. It is all about logic! I still have other small problems, but I think I can handle that now that I know how VBA thinks

Thanx a lot!

Andre