Getting error number 1004

[destiny4me]

Hi All,

I have written the below function

Please Login or Register  to view this content.

While executing I am getting error number 1004. Can any one help me to resolve this issue?

[xladept]

Hi destiny,

Try qualifying your assignment:

Please Login or Register  to view this content.

[destiny4me]

Nope same error

[destiny4me]

Attached the workbook for reference.

[Norie]

UDFs can't be used to alter values on a worksheet.

[xladept]

Hi Destiny4me,

I may have figured it out - the error will always be generated, but we don't need to see it since the macro works this way:

Put the change code in the sheet1 module and comment out the error message:

Please Login or Register  to view this content.

in sheet1

Please Login or Register  to view this content.

in module 1

[destiny4me]

it works

[xladept]

Yeah, sometimes the VBE protests too much