Excel Range Leftmost and Rightmost columns

[msnews.microsoft.com]

Hi,

if i have an excel range, how can i find out the leftmost column and right
most column in the range easily?

is the only way to examine each column in the range?

thanks

 

[Jeff Hopper]

Dim rng As Range
Dim leftCol As Range
Dim rightCol As Range

Set rng = Selection 'or whatever range you're after
Set leftCol = rng.Columns(1)
Set rightCol = rng.Columns(rng.Columns.Count)

 

[msnews.microsoft.com]

thanks!

Dim rng As Range
Dim leftCol As Range
Dim rightCol As Range

Set rng = Selection 'or whatever range you're after
Set leftCol = rng.Columns(1)
Set rightCol = rng.Columns(rng.Columns.Count)