Excel Column Selection
I've found a problem with selecting columns in Excel.
I tried using the following VBA script:
Columns("K:L").Select
This should select columns K and L. However, this selected columns F to W.
This was because there were merged cells on the spreadsheet. Cells F4 to W4 were merged. Removing these allowed the columns to be selected.
I tried using the following VBA script:
Columns("K:L").Select
This should select columns K and L. However, this selected columns F to W.
This was because there were merged cells on the spreadsheet. Cells F4 to W4 were merged. Removing these allowed the columns to be selected.
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home