WHy this debug error

Hi I just pasted this vba code and it works for all the cells only cells in one column it gives error and while debug show this value highlighted ".InputMessage = Target.Value"

Please Login or Register  to view this content.

Thanks
mp

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Do you have merged cells?

Try this....

Please Login or Register  to view this content.

Hi, maximpinto,

...and it works for all the cells only cells in one column...

Run Time Error 13 if you happen to let it run on multiple cells as they all are part of Target - you must break it down to a loop to run on each cell. And the code will work in any cells that are selected by curosr or mouse - I would break the range down.

Limiting to Column C and adjacent cells:

Please Login or Register  to view this content.

Ciao,
Holger