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.