Hello yesterday I faced one problem with my Excel. I have Excel shit which contains column names in row#1. Basically I am facing problem with excel macro. I want to write excel macro that will appear for column names no matter which that had 'ID' or 'AMT' in it, and be supposed to format complete column apart from 1st row which has name in 0000-000-00 for ID and $ 000,000,00.00 for AMT. So that time devoted in formatting every column will be concentrated. I would really appreciate if somebody be acquainted with solution about it. Thanks in advance.