Yes, I was able to declare it within a subroutine but it restricts s1
to remain a local variable rather than a global variable. When I
tried putting it in declarations on top of all the subroutines, VBA
denied. Is it possible to declare Set s1=worksheets("input") as
global.