| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro won't select columns
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro won't select columns
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 "Vick" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorted but did not select all columns | Excel Discussion (Misc queries) | |||
| Select Number of Columns and Print Macro | Excel Discussion (Misc queries) | |||
| Autofilter - on select columns | Excel Worksheet Functions | |||
| Select second columns only | Excel Discussion (Misc queries) | |||
| How do you select two cells in different rows and columns with ou. | Excel Discussion (Misc queries) | |||
Linear Mode
