View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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