Getting compile error 'Wrong number of argument or invalid property assignment'

Hi,
I'm getting compile error 'wrong number of argument or invalid property assignment' on the first line word 'range'.

Please Login or Register  to view this content.

The code is:

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you.

should be

Please Login or Register  to view this content.

Hi Andy Pope,
Thank you. Now the error has gone but another error 'compile error 13 time mismatch occur on line:

Please Login or Register  to view this content.

The code is:

Please Login or Register  to view this content.

Solution please!

Thank you.

The is just gibberish.

You can not use multple references when using Cells object. You need to use Range object.
Also you can not just use a single mention of a column.

Please Login or Register  to view this content.

Hi Andy Pope,
Thank you for guidance. Now the error has gone. I have made necessary changes as per my knowledge.

Please Login or Register  to view this content.

Please go through it and suggest me a correction.

Thank you.

You changed object cell to be rngCell but have not updated that code.

Please Login or Register  to view this content.

Hi Andy Pope,
Thank you. I got my mistake. Now I'm getting compile error 'syntax error' on the line:

Please Login or Register  to view this content.

I think after this revision the problem will be solved.

Thanking you.

I assume you code should be,

Please Login or Register  to view this content.

Hi Andy Pope,
Thank you. It's working fine.