Getting compile error expected function or variable

Dear friends,
I'm getting compile error expected function or variable.
I also want to remove limit of max 5 lc from the code

Any help will be highly appreciated.

Thanking you in anticipation.

Please Login or Register  to view this content.

your trying to make something equal a macro?

Could you explain what you are trying to do?

Hi davesexcel,
Thank you for your response.

Actually I want to recor the receipt number a8 and date-time b28 on register sheet infront of that particular number which I enter in g7 lc sheet.

Thank you,

Hello davesexcel,
Thank you for your response to solve the problem. Now I have solved the problem of ‘expected function or variable’. It’s working fine but still I have two problems to solve as stated in my first post.

Condition require for cell b4 as follows:
If receipt cell b4 = receipt number then exit sub. If I scroll the cursor on b4 then there should not be any action, no change in receipt number till I enter a next register number in cell g7.

Remove limit of maximum 5 lc. It should be unlimited. No any other change is require.

I have attached a corrected workbook for your perusal.

After this amendment the problem will be solved.

Thank you,

I'm not sure, your code is hard to follow.

Hi,
Thank you. I solved the max lc problem. Now I have only a problem of annoying running of macro for which I posted a thread today morning but still not received a solution.

I request you to look into this matter and suggest me a solution.

http://www.excelforum.com/excel-prog...-of-macro.html

Thank ing you in anticipation.