Dealing with column headers
 

Hi...

I am learning about writing macros. I always stuck up at one point.
I need to do various activies on columns based on their headings. e.g. I
have to replace all "NA" in the column whose heading is "TOWN". Currently I
write the macro using column number. But if the columns gets shifted, then
this macro will not work. How can I extract column number by identifying its
heading?

Regards,
Pawan

Dealing with column headers
 

colNo = Application.Match("TOWN",Rows(1),0))

and use colNo.


--
__________________________________
HTH

Bob

"Pawan" wrote in message
...
Hi...

I am learning about writing macros. I always stuck up at one point.
I need to do various activies on columns based on their headings. e.g. I
have to replace all "NA" in the column whose heading is "TOWN". Currently
I
write the macro using column number. But if the columns gets shifted, then
this macro will not work. How can I extract column number by identifying
its
heading?

Regards,
Pawan

Dealing with column headers
 

Thats perfect...

Thanks Bob.. :-)

"Bob Phillips" wrote:

colNo = Application.Match("TOWN",Rows(1),0))

and use colNo.


--
__________________________________
HTH

Bob

"Pawan" wrote in message
...
Hi...

I am learning about writing macros. I always stuck up at one point.
I need to do various activies on columns based on their headings. e.g. I
have to replace all "NA" in the column whose heading is "TOWN". Currently
I
write the macro using column number. But if the columns gets shifted, then
this macro will not work. How can I extract column number by identifying
its
heading?

Regards,
Pawan