Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Autofit Rows or Columns Containing Merged Cells in Excel
Thanks for this response. Whilst this does work, what I am also trying to avoid is changing the row heights, so that there is a need to merge vertically as well as horizontally across cells.- AliR
- Post #3
- Forum: Microsoft: Office
-
Autofit Rows or Columns Containing Merged Cells in Excel
The Auto fit feature in Excel does not work when the Wrap Text and Merge Cells option are checked in the Cell Format Alignment dialogue. This is a recognised "feature" by Microsoft. Knowledge Base Article - 212010 refers. One solution is to place a text box over the cells where you...- AliR
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Microsoft Excel
The following copies data from one workbook to another Sub CopyData() ' ' CopyData Macro ' Macro recorded and edited 22/01/2003 by ARennie ' Workbooks.Open Filename:="O:\Accounts 02\TB Test.xls" Range("A11:B11").Select Range(Selection...- AliR
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Writing Excel VBA script to handle range names
I am importing a file into excel, and want to assign a range name to the import. The file changes in the number of columns and/or row that are imported. I am trying to write a macro that will change the the number of rows and columns of that named range each time the file is imported. Can...- AliR
- Thread
- Replies: 5
- Forum: Microsoft: Office
