VBA code for searching Particular Column and formating the column 1

[rajltd]

I am coding a Excel macro in VB for searching a particular column (treat as header) from a number of worksheets in the workbook. That particular column Eg. Accessories, can be in more than one worksheet of the workbook, but it is always in the 3rd column of that particular worksheet (if there) of the workbook. The reason being I want to format the column size from 10 to 50 for that particular column.

Any help will be very much appreciated.

Thanks

 

[SkipVought]

Hi,

Assuming that your column heading value is Accessories and if it exists on a sheet is in column C row 1...

for each ws in worksheets
  with ws.cells(1,3)  
    if .value = "Accessories" then
      .entirecolumn.columnwidth=70
    end if
  end with
next

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com