How to determine if Range spans more then one row??

[gpsmith]

I have vb putting a cell range in a variable. Is there a way to determine if the range spans more then one row?

The variable can contain a range that is on one row - e.g. "$B$5:$E$5"
or
The variable can contain a range that spans rows - e.g. "$b$5:$C:$7"

Subsequent logic can only operate on a single row so I would like to put out an error message if the range spans rows.

Thanks in advance,
George

[royUK]

How is the range assigned?

[gpsmith]

variable is populated via vb statement myRange = currentActiveCell()

where currentActiveCell() is the following function:

Function currentActiveCell()
Application.Volatile
currentAcitiveCell = Selection.address
end Function

[shg]

Please edit your post to add code tags.

Please Login or Register  to view this content.