Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |