Compile error 91 object variable with block variable not set

[mso3]

Hi friends,

I’m getting compile error 91 ‘object variable with block variable not set’ on the following line:

Please Login or Register  to view this content.

If I enter a letter ‘L’ in column ‘C’ on ‘Information’ sheet then
It should be change to upper case automatically
Column ‘g’ should have a value ‘L’ automatically

The code is:

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you,

[jindon]

Just replace "cell" with Target, no need of variable "cell".

[mso3]

Hi jindon,
Perfect! It's working fine.

If a user enter a 'L' in lower case then it's not working. So it should be change to upper case automatically to get perfect output.

Shall I use a 'upper' function or insert a code to achieve it?
Please suggest me a code to achieve it.

Thank you and have a nice day.

[jindon]

VBA has UCase, LCase function

Please Login or Register  to view this content.

[mso3]

Hi jindon,
Perfect! Thank you.

Now it's working fine.