it's quite weird..
when i put random values in i see the sheet run in the back for a milisecond but then it goes back to vba
whereas when i put the correct values in i get told that the subscript is out of range