08-22-2010, 10:18 AM
If something is stored in a variable, it cannot disappear while the macro is running.
If the macro runs several times, and a variable must be preserved, use global variable.
str+ globalVar
Maybe I can help if you post whole macro. Insert comments where the variable is populated and where compared.
If the macro runs several times, and a variable must be preserved, use global variable.
str+ globalVar
Maybe I can help if you post whole macro. Insert comments where the variable is populated and where compared.
