asked on Excel VBA and cell value
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?
Thanks.
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?
Thanks.
Microsoft Excel
Last Comment
TechPilot9133
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Actually, this is better:-
If VarType(SourceRange) = vbString Then
---->Do something here
End If
Matt
If VarType(SourceRange) = vbString Then
---->Do something here
End If
Matt
ASKER
That answer does exactly what I asked, but it does not help me whith what I am trying to do. I will do further tests and hopefully formulate my question better. Sometimes finding the proper way to ask the question is the harder than us newbs think. Thank you for the responses.
If Application.WorksheetFunct
----->do something here
End If
Hope this helps,
Matt