What I have is an excel sheet that a user enters a tag, start time and end time.
This tag is a digital tag with two states ON/OFF. I would like to be able to write to an excel cell how many times the state changed to ON in the defined period but I have been having trouble implementing this functionality in VBA.
I was using this post as a reference: http://vcampus.osisoft.com/discussion_hall/add_in_microsoft_development/f/11/p/3301/17876.aspx#17876
but have not been able to adapt it for my purposes.