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:

Please Login or Register  to view this content.

Any help or direction would be appreciated. Questions are more than welcome, often times my posts are unclear.

Thanks!

Hi

Just call Column on the range variable - it will return the column number of the first column in the range:

Please Login or Register  to view this content.

Richard

EDIT: note this will potentially fail to return the left-most column if the range contains multiple areas