Coding Error I can't fix

[j_Southern]

The following code gives an "Application Defined or Object defined" Error, at the line .Range(Cells(r,4+b)).Value = SupergangAr(4,a). All the addresses are correct and contain values.
I think my coding must be wrong but I can't see why.
Can anyone help please.

Please Login or Register  to view this content.

Thanks in anticipation
John

[6StringJazzer]

The Cells reference is associated with a sheet. In this case is it unqualified, therefore will default to the active sheet, which may not be the same as sheet Order. You cannot refer to a range in Order that references Cells from a different sheet.

Add a dot in front of Cells.

Please Login or Register  to view this content.

[j_Southern]

Six string,Thanks for your interest.
I have modified the code to:-

Please Login or Register  to view this content.

To make sure that r was not a string and to add your qualifying dot. Same error message though.
All the variables have expected values.
John

[6StringJazzer]

All the variables have expected values.

What are the expected values? Specifically, what are the values of r, b, a, and SuperGangAr(4, a) at the point where the error occurs?

In general I would also suggest that you use Option Explicit and declare all variables. It appears that you allowing them to default to Variant. This may not be causing your problem but when you say that you use CInt to make sure r is not a string, it suggests there could be typing issues.

[j_Southern]

I take your point about not declaring variables. It is a bad habit I have got into.
I will rewrite with everything declared just in case

r= 4
b = 1
a = 0
SuperGangAr(4,a) = "Gang1"

John

[romperstomper]

If the cell referred to by .Cells(r, 4 + b) doesn't contain either the address or name of another range, you will get an error. If you're just trying to refer to that cell, use just:

Please Login or Register  to view this content.

[j_Southern]

RomperStomper,
Thanks for your advice, which was the answer to my problem. I don't fully understand the use of .Cells(.... and Range.Cells(.... so that's more homework to do.
I do think that this forum (and its gurus and experts) is a wonderful help to beginners like me. Thanks again
John