[QUOTE=NateO;1777]You're welcome Sam.

Hi I wanted to define names automaticly from Row Column Head

Example
Ahmedabad Bombay Kolkata
Apple 10 14 17
banana 11 15 18
Orange 12 16 19

I want to automaticaly define name for 10 as AhmedabadApple, 11 as AhmedabadBanana, 14 as BombayApple so and so forth.
I don't know how to do that. Please help me on it.

I tried find out the function for it but think there is none. I am also not that good at VB. Would please give me micro by which I can do it.

Many thanks,

Dipen Mandalia