if not intersect

  1. Q

    "If not intersect" question

    I have a line of code to trigger a macro when a cell in specified column range is selected: If Target <> "" And Not Intersect(Target, Range("D6:D1048576")) Is Nothing Then Is there a simple modification I can make so the macro will not be triggered when I insert a new row?
  2. H

    Private Sub Worksheet_Change(ByVal Target As Range) Not working

    Hi, I am trying to trigger Macros according to the value cell A2 of Sheet1 is changed to. After changing the value in A2 nothing seems to be happening. What am I missing? Cell A2 is merged with everything up to cell B7, but I have also tried without the cell being merged. Private Sub...
    • HarryP96
    • Thread
    • call call a macro if not intersect vba worksheet_change
    • Replies: 8
    • Forum: Excel Questions
  3. E

    Private Sub to looking at two different cell changes

    Is there a way to have a private sub that runs different macros based on different cell changes? The below code only executes the HideRows macro when I change the value in C11. It will not execute ClearData macro when I change C10. Is there a way to make it work? Private Sub...
  4. E

    Why the row selected is displayed in negative value : Range ().value = Target.row

    Hello guys, I have just joined this amazing place and I'm still novice in VBA . From the code below, I would like to display rows number of selected cells in cell "A4". The issue is I have the first number displayed in negative value without parenthesis. However I want to display a positive...
  5. C

    Application.Wait & If Not Intersect Problems

    Hi, I have a workbook which copys data from a web data connection. The problem I'm having is the website updates each minute, with various amount of data, until an upload is complete (this can take a while sometimes), and I don't want the macro to continue until all data is uploaded. So I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top