Confirm the Range / Selection contains more than one cell

[Guentjo]

I have a macro that should only be run if the user has selected two or more cells. How can I check with vba that the Range contains more than one cell?

 

[acw]

Hi

One way

Selection.Cells.Count

so if selection.cells.count > 1 then.....


Tony

 

[Guentjo]

That'll do. Thanks