select columns

  1. F

    Spell Check certain columns only in VBA

    Hi, I have a piece of code that inserts a row of data at the bottom of an existing range, and then what I'm after is for a spell check to take place on that new row. At the moment, the code below works fine .... it spell checks all the visible columns in that particular range. To make it...
  2. 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...
  3. 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)...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top