select columns

  1. H

    Change column width

    Hi, I want to change column width on the following columns in my worksheet: O, S, W, AA, AE, AI from 2 to 1. What I have is this: Range("O:O,S:S,W:W,AA:AA,AE:AE,AI:AI").Select Selection.ColumnWidth = 1 The problem is that it is selecting all columns from B to AI. I have some merged...
  2. J

    Select Columns in Worksheet based upon listbox selection

    Hi, Looking for some VBA help, this is probably very simple (hopefully :)). I have a form that allows user to select a worksheet from the current workbook using a combobox, the listbox will then display the contents of the selected worksheets header row (where row 1 is always the header)...

Some videos you may like

This Week's Hot Topics