Results 1 to 3 of 3

Using VBA how do I return the column number of first column in a user inputted range?

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2009
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2007
    Posts
    51

    Using VBA how do I return the column number of first column in a user inputted range?

    Hello,

    I'm creating a macro that creates a co-ocurrence matrix from variables that are adjacent to each other.

    In order to proceed, I need to know how to return the column number of the first (leftmost) column in a range that the user selects.

    How I obtain the range:
    Dim HeaderRange As Range
    'Prompt for Header Range
        Set HeaderRange = Application.InputBox(prompt:="Select the header row (These will be used to generate and label the matrix)", Type:=8)
    Any help or direction would be appreciated. Questions are more than welcome, often times my posts are unclear.

    Thanks!
    Last edited by NukedWhale; 02-19-2009 at 06:24 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