If Selection..

[jstevens]

Is it possible to determine the first and last column of a "selection" of cells?

Example of what I'm trying to achieve.

Code: Select all

IF a range of cells is selected and the Columns are "C to F" then 
     process some code
ELSE
     do nothing
END IF   

[HansV]

If the selection is a single contiguous rectangular area:

Code: Select all

    Dim FirstCol As Long
    Dim LastCol As Long
    FirstCol = Selection.Column
    LastCol = Selection.Column + Selection.Columns.Count - 1

FirstCol and LastCol are column numbers, so columns C to F would correspond with FirstCol = 3 and LastCol = 6.

[jstevens]

Hans,

Thank you.