Results 1 to 3 of 3

Selecting an entire column using a reference defined in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Tamworth, Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Selecting an entire column using a reference defined in another cell

    Hi, all. I'm very new to VBA and Macros so apologies in advance for this simple question.

    I need to highlight an entire column to the right of the Active Cell. How far to the right is defined by a number in A2. I had considered using the following:

    Range("A1").Offset(0,x).Select
    ActiveCell.EntireColumn.Select
    whereas x = a number contained in A2.

    What do I substitute here for the x, or is there another way?

    Many thanks in advance.

    Darren
    Last edited by Pippin66; 10-18-2012 at 09:05 PM.

Thread Information

Users Browsing this Thread

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

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