I have a variable on a sheet that changes based on the row being read while the loop is executed.
Dim rowIndex as Integer
Dim SourceRange as Variant
SourceRange = ("A2")
In the loop I have this;
SourceRange = ("A") & rowIndex
The SourceRange is changing properly as the loop is executed, BUT,
I am trying to figure out of the variable SourceRange contains a string. How do I get that value from SourceRange?