Worksheet_calculate event

**jackandjill** · 06-25-2010, 02:43 AM

Hi i used to have the below code in Worksheet_Change event now due to necessity i am changing it to Worksheet_calculate event

Code of Worksheet_Change Event

Please Login or Register  to view this content.

Code THAT I HAVE TRIED AND NOT WORKING for Worksheet_Calculate event

Please Login or Register  to view this content.

the Calculate event does not initiate please advise

**royUK** · 06-25-2010, 03:23 AM

Is the code in asheet called WorksheetFunction?

**jackandjill** · 06-25-2010, 04:57 AM

No.
i have attached the file for your viewing please take a look.

**royUK** · 06-25-2010, 05:23 AM

I don't know what you are expecting from the code, you don't declare your variables. Also, it's confusing to call the sheet WorkSheetFunction.

maybe this

Please Login or Register  to view this content.

**jackandjill** · 06-25-2010, 05:43 AM

Sorry my bad yes i did not declare the variables but even after declaring no difference no values are being put in cells b1 and c1

perhaps this will shed more light towards my problem

http://www.excelforum.com/excel-prog...-refining.html

http://www.excelforum.com/excel-prog...ther-cell.html