Application-defined or object-defined error

[minmark]

Dear Gents,
I've got errornotice for following code:

Cells(ActRow, 41).Value = NewUseVol

I already define ActRow and NewUseVol(=0) (with public)

Would you please suggest any solution to handle this error?

Thanks.

 

[Rick Rothstein]

Dear Gents,
I've got errornotice for following code:

Cells(ActRow, 41).Value = NewUseVol

I already define ActRow and NewUseVol(=0) (with public)

Would you please suggest any solution to handle this error?

Put a BreakPoint on that line of code and run the procedure it is in again... check the value of ActRow (I'd be willing to bet it is zero).

 

[minmark]

Hi, Mr. Rick.
I put a breakpoint and check Actrow with my mouse arrow and ActRow = 14.

 

[Rick Rothstein]

Hi, Mr. Rick.
I put a breakpoint and check Actrow with my mouse arrow and ActRow = 14.

In that case I do not see how that line of code can be generating the error you are reporting.

 

[minmark]

Mr. Rick.
Thanks, the code is not wrong here, some variable relate to target.row in other code cause this problem.
I fix them accidently.