rngb

  1. E

    VBA: Trying to pass Cells to Function Range parameters but is passing values instead

    This is a small part of a bigger project which iterates through spreadsheets using Cells and Row and Column values. It is easier to manage than working with Ranges and String values (e.g. "A1"). In the example below, I'm trying to pass the Cells as ranges, and then the method will evaluate the...
  2. P

    Enter Remaining Values From RangeB into Range A

    Hi can anyone help with vba code? I have two ranges A and B that mirror each other with headers A-G range A "T5:Z7" sheet1 range B "AC5:AI7" sheet1 range B calculates values from another sheet and range A keeps a record of remaining values when I have remaining values anywhere in 'range B'...
  3. E

    vba copy cell until blank loop

    Hi, I am looking to copy a date for a range, then a different date for a 2nd range and repeat this until all the dates that are found in the column have been copied next to the event. I can find the date and copy it to where I like, however I'm unsure how to copy it down for that set range...
  4. X

    check if cell in named range

    Hello, I have two sheets sheetA and sheetB with two names ranges rngA and rngB respectively. rngA in sheetA has one column and contains cell addresses (like, $F$6, $H$2, $G$3, ...) rngB in sheetB is say $F$3:$H$9 I need to delete cell addresses in rngA that are not in rngB. For example, $H$2...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top