Selecting columns in excel
Closed
damienjames0
Zohaib R
- Posts
- 2
- Registration date
- Thursday March 28, 2013
- Status
- Member
- Last seen
- March 28, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Selecting columns in excel
- Excel vba select column by header name ✓ - Forum - Excel
- Uneditable selected Columns/Rows/Cells Excel ✓ - Forum - Excel
- Compare two columns in excel for partial matches - Guide
- How to create a drop down list with multiple columns in excel - Guide
- How to screenshot selected cells in excel - Guide
2 replies
damienjames0
Mar 28, 2013 at 02:02 PM
- Posts
- 2
- Registration date
- Thursday March 28, 2013
- Status
- Member
- Last seen
- March 28, 2013
Mar 28, 2013 at 02:02 PM
The problem appears to be caused by 'merged cells". If I un-merge all the cells then the columns.select (or range.select) seems to work ok. So how can I get it to work on a worksheet with merged cells?
Zohaib R
Mar 28, 2013 at 02:17 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Mar 28, 2013 at 02:17 PM
Hi damienjames0,
To select the range A:H on the active worksheet, I use one of the following:
ActiveSheet.Range(Cells(1, 1), Cells(1048576, 8)).Select
ActiveSheet.Range("A:H").Select
ActiveSheet.Range("A1", "H1048576").Select
These work with "Merged Cells" as well.
Do reply with results.
To select the range A:H on the active worksheet, I use one of the following:
ActiveSheet.Range(Cells(1, 1), Cells(1048576, 8)).Select
ActiveSheet.Range("A:H").Select
ActiveSheet.Range("A1", "H1048576").Select
These work with "Merged Cells" as well.
Do reply with results.