Selecting columns in excel
Closed
damienjames0
Posts
2
Registration date
Thursday March 28, 2013
Status
Member
Last seen
March 28, 2013
-
Mar 28, 2013 at 01:43 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 28, 2013 at 02:17 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 28, 2013 at 02:17 PM
Related:
- Selecting columns in excel
- Number to words in excel - Guide
- How to take screenshot of selected area in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
2 responses
damienjames0
Posts
2
Registration date
Thursday March 28, 2013
Status
Member
Last seen
March 28, 2013
Mar 28, 2013 at 02:02 PM
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
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 28, 2013 at 02:17 PM
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.
