intersect

  1. D

    Argument not optional problem If Not Intersect Private Sub Worksheet Change

    I have a woworksheet which gathers data from an external source and is continually updating - similar to stock prices. I am trying to copy a range of data in i8:i40. Have tried numerous ways but without success. Reading various forums the below seems most logical to meet my needs but i'm...
  2. Y

    VBA to intersect cell changes (both data validation) and action separate functions

    Hi Everyone, on my worksheet I have two cells B3 and C3 which have data validation. So what I want to do is when either of the cells change, it will update two pivot table's filters. (Target & Actual) Below is what I got working when looking at only B3 and updating the Region. The values...
  3. S

    VBA - Unable to delete objects w/ INTERSECT if using Data Validation

    Good morning! Newbie here, but I've exercised about all the Googling I can do to find the solution and I just have not found one anywhere. Wondering if any expert VBA guys/gals can help a rookie out... Problem: When manually selecting cells that use List-style Data Validation, I can no...
  4. M

    VBA Line and intersect

    Hi Looking to see how I could utilise VBA code to draw a vertical line from a defined range (say cell B1=0, B2=1000) then horizontally intersect the vertical line down the page, to scale, from a value in another cell. For example, the vertical line would cover cells A1-A20, with A1 value =0...
  5. M

    Recording Time of Changes in another Worksheet

    MAJOR AMATURE ALERT! I'm trying to code a module to record the time of changes made to a workbook (several worksheets) to another worksheet. I can get the code to record the time of the change for a range with multiple columns to the next cell over (xOffsetColumn = 1). I am trying to send that...
  6. M

    Select a Shape that Intersects (touches) a Cell (range) using VBA

    Using VBA code, I will be placing a shape somewhere within a large cell range. But FIRST I NEED TO REMOVE THE SHAPE that may already be there. I know the shape will intersect or touch a certain cell (G13). So, I need the code to simply select this shape and then, I can move it to another...
  7. P

    How to create a table to give me certain X & Y values

    Yea i know, that title is a little weird. But this is what i am trying to do. I have somewhere an example of this, but didn't have time to figure out how they did it. I have 2 sheets with X & Y data. Y is in bounds, X has temperature and a scale for altitude. Where they intersect is the value...
  8. V

    Set Range for Loop of Rows

    I am trying to set a range for a set of columns (rg2) and rows by using Intersect. The rows are only to be selected for the range where there is a conditional "x" mark in a column. I can not set this loop as a range somehow or include this in the intersect range setting. I appreciate anyone's...
  9. N

    Intersect a Row and Various Columns

    Hello everyone. I'm having some issues at work with a task that my boss assigned to me. I need to know how to intersect a Row with various Columns. Intersected data range must be plotted as Values and then columns header (dates from Jan to Dec) must be a xValules as well. Sorry for my English...
  10. L

    Selective elimination of code execution.

    In the code below, recording TO respective sheets works well... recording FROM respective sheets changes the value in B3 thus execute the recording TO respective sheets again... the former is essential, how to stop the latter ? Private Sub Worksheet_Change(ByVal Target As Range) Dim myWS As...
  11. E

    Autofilter, copy & paste vba not working

    Hi can someone have a look at the below and help with why it's not working? Warning it's messy! Sub Searchproper() ' ' copyandpaste Macro ' ' Sheets("HR Advice & Admin").Select FilterString = Sheets("Offer Received").Range("G5").Value ActiveSheet.Range("$A$1:$AS$286").AutoFilter...
  12. C

    Method Intersect of Object _Global Failed

    I don't have a lot of experience with VBA and there's one error that keeps bugging me. The following code does exactly what I want, with the exception that I get the "Method Intersect of Object _Global Failed" error every time I update cell B3. What am I doing wrong? I thought I was being...
  13. L

    how to use Intersect

    I have a change event sub below and I want to trap changes made on columns A to B only. How do I use Intersect on this sub? many thanks Dim rngLastChange As Range Private Sub Worksheet_Change(ByVal Target As Range) Set rngLastChange = Target If [E2] > [F2] Then MsgBox...
  14. M

    Can't get Intersect command to copy formula

    I have a sub that copies a formula into a group of cells. There are two options for what formula it will put in the cell, depending on which option button is selected by the user. It isn't working, and I'm not sure why. Note: I don't want to call the cells by their Column Letter and Row...
  15. P

    Time intersect

    Hi all, Is there a way to get the number of hours intersected by 2 time periods? For example: 09:00 to 18:00 vs 21:00 to 06:00 = 0 hr (no intersection) 18:00 to 03:00 vs 21:00 to 06:00 = 5 hrs (this is from 22:00-03:00) 00:00 to 09:00 vs 21:00 to 06:00 = 6 hrs (this is from 00:00-06:00)...
  16. W

    2 Way Lookup

    Hello All I am currently trying to do a 2 way lookup with unsorted data. So let's say that I want to return the value for where the value matches number 4 on my left column and G on the overhead row. So where 4 and G intersect return that value. In this case it would be 700. and the same for...
  17. R

    What's This Graph Called (Not Really an Excel Question)

    So most charts plot a positive X and positive Y and look kinda like this: Others have negatives - so the zero point is in the center, where the X and Y axes intersect: Do these two different graphs have different names? Like, if I said I wanted a "transgential interspecular graph", a...
  18. G

    Excel 2010 VBA Intersect table change accessing current row / column values for updating

    Maybe I am not providing the best search terms, but I can't find a clear answer (probably due to my lower Excel experience) Here is an example. Let's say... I have a table called tbProjectionsBudget that is populated from a SQL query. I have example columns (Item, Proj Qty, Proj Cost, Proj...
  19. S

    Limit message from MsgBox only to when related cells change (not any cell))

    Hello, everyone. This is my first post! And I'm also brand spanking new to VBA, so bear with me. First, I'll explain what I'm trying to do. I manage a work order system in Excel and I want to pop up a message to the users inputting new work requests that alerts them if their requested...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top