Using Split Function on String with no spaces
ExcelMonkey,
You have to use Split ?
With ThisWorkbook.ActiveSheet.Range("DF456")
Debug.Print .Column & " : " & .Row
End With
NickHK
"ExcelMonkey" wrote in message
...
Bob I have already extracted the address as a string. So I will not be
using
the range object with the address property. I think what your code does is
relace a "$" with a "". I don't have a "$" to replace. I simply want to
split the string inbetween the F and the 3.
Split("DF345", "?????", "")
"Bob Phillips" wrote:
Try
Split(rng.Address(True, False), "$")
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"ExcelMonkey" wrote in message
...
I have a cell address - assume its relative - "DF456". I want to
split
this
up by colunm address and row address "DF" and "456". I was hoping I
could
use the Split funciton But I am not sure what delimiter to use if I am
going
to use the Split function - if its even applicable.
Or am I forced to loop through the string find the starting/ending
points
of
Letters/Numbers and use the replace function to redefine (i.e.
replace("DF456","DF", "") = "456" and replace("DF456","456", "") =
"DF"
Thanks
EM
|