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.
No comments:
Post a Comment