Run-Time Error '-2147417848 (80010108)

Hi folks,

I'm using a piece of code to Data-Validate a couple of columns and it keeps falling over with the error message:
Run-Time Error '-2147417848 (80010108)': Automation error. The object invoked has disconnected from its clients.

The code stops at the red line below:

Please Login or Register  to view this content.

Can anyone enlighten me why this happens, please?

Seamus

Hi

Shouldn't Columns be qualified?

Try adding the dot before Columns

Please Login or Register  to view this content.

HTH
lecxe

Strange,

I've tried again this morning and am getting a different error message:

"Run-Time Error 1004: Application-defined or Object-defined error"

Even having tried both your suggestions (shg and lecxe) I'm still having problems.

If anyone has any other ideas on how to either deal with the issue or suggest another workaround I'd be grateful.

Col B should only allow dates to be added (1 Apr - 31 Mar) and Col C should only allow numeric data. I thought that Data-Validation was the way to go and decided to add the code below to a button which would add the Data-Validation for me.

But if there is other code out there along the lines of:

DUMMY CODE:

"For each cell in range" or "worksheet change"
Cell.value must be numeric
Next Cell

or something similar I'd like to hear about it.

Many thanks

Seamus

Your code will replace formulas with their uppercase results ...

shg,

But none of the cells are having formulae entered - only Surname, Date and No of Days Leave taken.

Thanks anyway

Seamus

shg,

I think I see what you meant :
the line If IsNumeric(Target.Value)

I've now changed that part of the sub to:

Please Login or Register  to view this content.

Is that better?

Thanks

Seamus