This post originated from an RSS feed registered with .NET Buzz
by Richard Jonas.
Original Post: Excel Column Selection
Feed Title: Richard Jonas
Feed URL: http://feeds.feedburner.com/blogspot/ouNA
Feed Description: Richard Jonas's blog about .NET, web development and agile methodologies.
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.
Previous Topic
