Hi there
One of the lines in my VBA code reads as follows
Dim oRange As Range
Dim oFindInRange As Range
Dim strSplitAddress As String
Dim blnNullRange As Boolean
.//lines of code//
.//lines of code//
.//lines of code//
.//lines of code//
strSplitAddress = Split(oFindInRange.Address, "$")(1)
what does the Split function do especially with does $ and (1) sign means in this scenario.
I have read up on split functions in excel help but i can't find specific reference to $ or (1) anywhere. Can you please advice?
Bookmarks