I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET. The code used the GoSub command which is no longer supported. So, I did some research and found out I should use a Call and Sub statements. So, I altered the code. I had some issues with the variables and found out I needed to put them outside subroutines.