Posted Code

Steved · May 26, 2004

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

Frank Kabel · May 26, 2004

Hi
after pasting the code you have to execute the macro. Take a look at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Steved · May 26, 2004

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

.