Trying(failing) to delete cell contents if...

[dubcap01]

Hi all,

Can anyone tell me why the following code fails?
I can't see a problem with it, but it just won't run as part of a userform_initialize code.
I want to check the worksheet "Model", and if a cell in column A is greater than 0 and corresponding cell in Column B is empty/blank/"", then column C should be updated to empty/blank/""
Any help much appreciated

Pete

Please Login or Register  to view this content.

[dubcap01]

fixed it... simple logic prevailed in the end, as did the addition of another beer's inspiration...

Please Login or Register  to view this content.

[:) Sixthsense :)]

Because objects needs SET keyword, but no need to assign the sheet to activesheet when you already have With statement.

Please Login or Register  to view this content.

[quekbc]

A few qualifiers are missing I think.

I don't think ActiveSheet = Sheets("Model") does anything.
Are you trying to activate the 'Model' sheet? If so, use
Sheets("Model").Activate

The With statement is not being used here. Should all Cells and Range refer to Sheets("Model")? If so...

Please Login or Register  to view this content.