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
|