Thread: Macro ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dok112[_36_] dok112[_36_] is offline
external usenet poster
 
Posts: 1
Default Macro ?


Hello all, I need some assistance please....I have a macro that i
putting a reference into a particular cell...the reference depends o
the cell that certain information is placed in, so it can differ ever
time the macro is run. Now, I need a way to take that cell and brea
it up into the letter and number. ie. Range("A3").value = "G33"...
have another macro that is going to use the value "G33", but I need i
to break it apart into the letter "G" and the number "33"...is thi
possible?? Any help provided will be greatly appreciated

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=38038