Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Posted Code
Hello from Steved
I was kindly given the below code I copied it and alt F11 and pasted it. I understand what it is supposed to do for example if cell A1 says "City" it gets changed to "1-City" The problem is I can not get it to work please help Thankyou. For x = 1 To 9 Cells(x, 1).Value = x & "-" & Cells(x, 1).Value Next x |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Posted Code
Hi
after pasting the code you have to execute the macro. Take a look at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany "Steved" schrieb im Newsbeitrag ... Hello from Steved I was kindly given the below code I copied it and alt F11 and pasted it. I understand what it is supposed to do for example if cell A1 says "City" it gets changed to "1-City" The problem is I can not get it to work please help Thankyou. For x = 1 To 9 Cells(x, 1).Value = x & "-" & Cells(x, 1).Value Next x |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Posted Code
Thankyou Frank, I wiil do as you ask.
Cheers. -----Original Message----- Hi after pasting the code you have to execute the macro. Take a look at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Frank Kabel Frankfurt, Germany "Steved" schrieb im Newsbeitrag ... Hello from Steved I was kindly given the below code I copied it and alt F11 and pasted it. I understand what it is supposed to do for example if cell A1 says "City" it gets changed to "1-City" The problem is I can not get it to work please help Thankyou. For x = 1 To 9 Cells(x, 1).Value = x & "-" & Cells(x, 1).Value Next x . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question not posted? | New Users to Excel | |||
Why my posting are not posted! | Excel Discussion (Misc queries) | |||
Finding questions I have posted | Excel Worksheet Functions | |||
Hi ..I posted some more info ..... | Excel Discussion (Misc queries) | |||
Re-posted need more detail | Excel Programming |