intersect range fails

  1. G

    Having trouble with INDIRECT formula to find intersecting rows and columns

    Hello, I am new to the forum, and hope someone can help. I need to create a "dashboard" for my end users that will automatically return a result like my sample below. <tbody> A B C D Over_4_Years Over_6_Years Over_8_Years 1 Salary_3 70,000 72,000 74,000 2 Salary_2 60,000 62,000...
  2. L

    VBA - How to add multiple ranges using intersect

    I'm new to VBA, and any recommendations on where to learn more would be greatly appreciated. I have a spreadsheet where various employee's will fill in the date the complete their assignment, then it flows to the next person. I am trying to use VBA to create a "username" stamp for multiple...
  3. B

    VBA Auto Filter Multiple Values in a PivotTable

    Hi there! First time posting here, you all have been amazing help while building out multiple projects. Really appreciate the community. I currently have two Pivot tables [PivotTable1 and PivotTable2] on a sheet("PivotTable"). I Have two Filters for each, one is Auditor, the other is Date...
  4. W

    PLEASE HELP!! finding intersection between two variable and inserting a value

    I've been trying for a couple weeks to create a vba that will fill out my project calendar for me. First thing i am trying to do is have the vba find the intersection between two variable and insert a string into the intersecting cell. I have tried various things such as match, vlookup and find...
    • wsk92
    • Thread
    • calendar intersect range fails intersection vba macro
    • Replies: 2
    • Forum: Excel Questions
  5. D

    Intersect command fails with different sheet ranges

    I'm trying to create an self updating drop down list. To achive this I found a code and adapted it to my workbook. Code works if it's in the sheet named "default" but when I try to redirect it to another sheet, it stucks in the code below, with this error (method 'intersect' object' _global...

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