Macro won't select columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that I want to select columns A & B, however it appears
because I have Merged cells in rows 1-3 it is selecting A thru P. Does anyone
know a way to prevent this from happening? My code is below.

Columns("A:B").Select
Selection.ColumnWidth = 5

Thanks
Vick
 
The way to avoid it is DO NOT MERGE CELLS. They are a pox on spreadsheets,
screwing up range selection, sorting, formatting, etc.

Virtually anything you can do with merged cells can be done WITHOUT merging
cells and without screwing up your spreadsheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resizing columns with a macro 7
Screen aspect ratios changes when macro runs 2
How do I add a formula to a macro? 4
Copy Sheet to Desktop 1
column width VBA question 7
Error message is Character Limit is over 1024 characters 2
vba macro 2
Excel 2003 accepting error message in macro 2

Back
Top