How do i check if the current cell is part of a range ?
One way:
If Not Intersect(ActiveCell, Range("TABLE")) Is Nothing Then
MsgBox "In TABLE"
Else
MsgBox "Not in TABLE"
End If
In article ,
"Luc" wrote:
Lets say a that i have named some cells TABLE
How do i check if the current cell is in the range with the name TABLE?
Thanxxxx
Luc
|