VBA language for a range of cells
Solved/Closed
proudcuban
-
Jun 11, 2010 at 07:32 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- VBA language for a range of cells
- Vba color range of cells - Forum - Excel
- Excel if range of cells contains specific text then return value ✓ - Forum - Excel
- How to apply a macro to a range of cells ✓ - Forum - Excel
- Excel vba pop up message depending on cell value ✓ - Forum - Excel
- Excel vba rename multiple sheets based on cell value - Forum - Excel
1 reply
rizvisa1
Jun 11, 2010 at 08:12 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jun 11, 2010 at 08:12 PM
see if this gives you some ideas
If Intersect(Target, Range("d3:f35")) Is Nothing Then
MsgBox "The active cell does NOT Intersect d3:f35"
Else
MsgBox "The active cell does Intersect d3:f35"
End If
If Intersect(Target, Range("d3:f35")) Is Nothing Then
MsgBox "The active cell does NOT Intersect d3:f35"
Else
MsgBox "The active cell does Intersect d3:f35"
End If