Changing Name in range

[sharafoly]

Hi..
I currently have a VB code that only misses something vital for me, i want to change the name in a cell and copy the new name in a new cell while leaving the old one as it is.

Here is and Example:

Cell F6="10-746"
I want cell E5 to be="746-10"
and cell F6 to be kept as it is.

N.B
i will add it to the end of a sub so i just want to copy and past plssss

 

[meldoc]

Hello and welcome

Try.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>x = Split(Range("F6"), "-")<br>Range("E5") = x(1) & "-" & x(0)<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[sharafoly]

Thank youu.. it works just fine i have another question plss..

Simply my code is used to make invoices by copying certain cells from a table and pasting it to the invoice the vb code goes as follows...

i run the macro and at the end of it it is ordered to run another macro to change the name in the range then another macro runs to save as the new name then another macro runs to open the new empty invoice again then i must rerun the macro all over again.. iam trying to make a loop so it goes doing this untill cell b2 is empty

 

[meldoc]

Hello again

I see that Peter, has answered your question, glad you got it sorted.

http://www.mrexcel.com/forum/showthread.php?t=499102