Click on a Cell and Run Macro

[xgunda420x]

Hello,

I am reposting thread. Thank you BigBas. I'm posting the sample report. Basically user clicks on cell "C6", macro goes to Sheet1, types "Commercial" in B21 and "Collection" in B25 and clicks on ABC Print Area Button.

I had to create macro for each value that I have in Sheet3 Column C. It worked for while but now I have more than 200 lines in Sheet3 Column C so I basically do not want to create 200 or so macros.

I would like to create something where user clicks on Sheet3!C6 and macro automatically takes the value of Sheet3!C6 and puts in to Sheet1!B25.

Any help would be greatly appreciated. Please help me guys. It is due tomorrow. My email address [email protected]. Below is my code for the worksheet.

Please Login or Register  to view this content.

Thank you so much.

[royUK]

Try this instead, change rang (v) to suit

Please Login or Register  to view this content.

[xgunda420x]

Thanks for reply. But for some reason its still does not work. It does something but it does not put the value in Sheet1:B21 and B25.

Can you please help me? Thanks

[xgunda420x]

OMG.

Its working. Thank you so much for your help. You're the best.