Changing a cell value if criteria are met

[strud]

I am trying to change a value in a cell in column C if the values in column A & B match certain criteria.

I have come up with the following code:

Please Login or Register  to view this content.

But it is producing an error- the debugger highlights this line:

Please Login or Register  to view this content.

Where am I going wrong here?

Thanks in advance for any help offered

[JOHN H. DAVIS]

Just a guess but maybe:

Please Login or Register  to view this content.

[strud]

Hi John, thanks for the suggestion, but unfortunately that returns an error and highlights the line in the debugger.

So I think it may need to be different..?

[:) Sixthsense :)]

I am really confused on this line

Please Login or Register  to view this content.

[strud]

Confused? as to what?

[ragulduy]

.value, .text etc are properties of, for example, a range object or something like that. vData is a variant variable, it doesn't have any properties, so you just need:

Please Login or Register  to view this content.

[StephenR]

Just drop the .Value.

[:) Sixthsense :)]

Confused? as to what?

Oops... Mis interpreted, please ignore

[strud]

Thanks guys...that got it.

Ockham's razor - the simplest answer is always the one your looking for

[strud]

as an extension of the abiove, it now doesn't return an error- but on testing the value is not changing when it should (i.e. the criteria are met).

Anybody any ideas why not?

[ragulduy]

Well, there is nothing in the code to assign the array to the worksheet range after you have changed the cells..maybe:

Please Login or Register  to view this content.

[strud]

Thanks yudlugar that's brilliant! I didn't realise I had to assign like that

I just had to remove the .Value from

Please Login or Register  to view this content.

as you advised above.

But other than it works perfectly- cheers