T
toolman
I want to call a subroutine whenever cells in a certain range on on
particular excel worksheet calculate. Currently it looks like this:
Private Sub Worksheet_Calculate()
Call price_tracker
End Sub
However, it is calling the price_tracker subroutine if a calculat
event occurs on any worksheet in this workbook.
How can I restrict the price_tracker program to running only when cell
on a particular worksheet change?
Even better would be if I could restrict the program to running if
calculate event occurred to a specific range of cells on th
worksheet.
Go easy on me I'm pretty new to this stuff
Ti
particular excel worksheet calculate. Currently it looks like this:
Private Sub Worksheet_Calculate()
Call price_tracker
End Sub
However, it is calling the price_tracker subroutine if a calculat
event occurs on any worksheet in this workbook.
How can I restrict the price_tracker program to running only when cell
on a particular worksheet change?
Even better would be if I could restrict the program to running if
calculate event occurred to a specific range of cells on th
worksheet.
Go easy on me I'm pretty new to this stuff
Ti