Results 1 to 8 of 8

Select Alternating Columns With Unknown End Point

Threaded View

  1. #1
    Forum Contributor amyxkatexx's Avatar
    Join Date
    11-23-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    128

    Select Alternating Columns With Unknown End Point

    Okay, so I have been googling to figure out how to write a macro that will select every other column on my workbook. All that keeps coming up is conditional formatting, which I do not want. I am not trying to highlight the columns in alternating colors, I just want to select them.

    I am starting at column F and I would like it to search until the end of the columns and select every other column ending with the last column with data in it.

    I know I could search by a specific row and tell it to find the first blank cell then offset it, but there is no particular row that will always have data in it, so I guess it needs to check by column until it finds the first column without any data in all rows and then offset it.

    Anyone know what I am talking about here?

    I know it should be fairly simple but I couldn't seem to find any answers anywhere else.

    Also, anyone know any good websites that have definitions for some basic macros? I'd love to start learning how to write this stuff on my own.

    Thanks.

    -Amy Kate
    Last edited by amyxkatexx; 03-09-2010 at 04:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1