VBA language for a range of cells
Solved/Closed
                                    
                        proudcuban                    
                                    -
                            Jun 11, 2010 at 07:32 PM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 11, 2010 at 08:12 PM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 11, 2010 at 08:12 PM
        Related:         
- Vba if target.address = range
- Excel vba target range - Best answers
- Target.address vba - Best answers
- Vba case like - Guide
- Excel online vba - Guide
- Vba check if value is in array - Guide
- Vba timer - Guide
- Vba color index - Guide
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Jun 11, 2010 at 08:12 PM
    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
