Hi everyone, I am creating a VBA function and I want to multiply the variable "con" by a number that will be next to the EventDateRange varible the vba function takes from excel. this new variable lets call it "prob" will have to follow a similar i loop as the Caldate below. "con" will be...