View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hemang Shah Hemang Shah is offline
external usenet poster
 
Posts: 1
Default Simple code to append numbers to the existing data in the cells

Hello

I have many colums of data (characters)

What I want to do is, highlight the required cells in the column and then
either press a button or whatever to trigger the code to run.

The code should append numbers to the existing data.


for e.g:

Column:

AA
BB
TH
XH
HB
SO

I want the code to do this:

30AA
31BB
32TH
33XH
34HB
35SO

Can the code ask me what is the starting number I want to append?

Can somebody show me a sample how to do this?

Thank you very much.