1. A

    VBA macro to loop through all workbook > find keywords in cell > copy adjacent cell > paste it in a master file into respective header

    I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...
  2. G

    Check if cells contain in dynamic range from different sheet

    Hello, this is my first post in this forum. I am currently doing a mini attendance sheet for number of employees. I have two different sheets, "A" and "B". In sheet B, there are a list of employees with each of them have 4 values (date). In Sheet A, there are column of days of a month. I would...
  3. S

    VBA - remove duplicates using range and cells functions together

    Hello, My objective: Delete specific range based on duplicates in a specific column , and shift cells up. I have a large spreadsheet with evenly separated data. I have an example attached of the outcome I want, but I would like to have it in a loop, where the script counts the columns and...
  4. M

    Trouble building multiple constraint filter in excel

    Hello everyone. Awesome forum! Hope everyone is having a wonderful Thursday. I was wondering if any of you could help me with this problem I have been having in excel. I am creating a filter function based off of raw data to give me data from that raw data given two date constraints and two...
  5. F

    Selecting pictures within highlighted cells

    Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...
  6. airforceone

    countifs not working in macro

    Sorry but I'm back again.... I hope everyone is well and good... anyway I have 2 Sheet (Dummy and Updated) from Sheet Dummy my code would supposedly insert my Sum and CountIfs formula in the designated cell in my Sheet Updated, although it runs but the problem is the total value does not...
  7. Jyggalag

    How do you make VBA code run automatically?

    Hi all, I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why? Thank you!
  8. V

    Unable to return the range but only the word "true"

    Here below is the code to create a draft email from excel, the current region is correctly selected but it doesn't show in email body correctly, it only shows a word "True", please see attached 2 pics. Please help as I have googled for days and cannot sort out the problem, thank you so much...
  9. W

    Range with Cells Function (Runtime Error - 1004 --> Application-defined or object Defined error)

    Hi am new to VBA, Could you please help on the below code. I have 2 workbooks and i want to copy the columns from one to another with the matching header. It shows an error in the following line as (Runtime Error - 1004 --> Application-defined or object Defined error)...
  10. J

    Range that auto-adjusts depending on Value in Column C and D

    Hello Ex-perts. What the sheet must do. In column B the number of eggs laid is counted. Once 4+ eggs are laid then the number of days is counted down from 24 in column E. Should there be a hatchling then the formula should reset for the next 4+ and the count down started over. I have the first...
  11. T

    Go To Cells That Dont Match From Table

    Hi Everyone, I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...
  12. P

    Get the address of cell from a for each element

    I'm very new to using VBA. I keep receiving a run-time error when I try to get the address of the cell. Sub Supervisor() SuperRange = Range("D3:D4") For Each cell In SuperRange If cell Like "*.*" Then MsgBox cell.Address Else MsgBox "nope." End If Next End Sub
  13. A

    Find intersection of two independent ranges and sum values at every coordinate

    Hi All, I have the definition of several ranges of straight lines: 1, 2, 3, 4 and 5, where I define the x- and the y- coordinates only for the start and end points of the lines. I would like to have a "Desired" range that sums the values in every coordinate of the range. I would like to do this...
  14. A

    Duplicates Highlight with condition from second column

    Hello world, so I have the sheet as seen in the attachment (I have included a picture) I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains...
  15. T

    Matrix Worksheet Function MInverse in VBA with Array

    I have a VBA script error out with "Type mismatch" on the Application.WorksheetFunction MInverse line. How else am I suppose to calculate a matrix inverse? What is the type mismatch? Both arrays are the same size and the matrix defined is invertible. Option Explicit Option Base 1 Function...
  16. G

    VBA to Only Highlight cells with a Value

    Hello, I'm looking to edit this script such that if there is no value under the first row and then don't copy it. So only copy the cells with values inside Range("D11").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select...
  17. N

    Sequential numbers based on cell value

    How do I enter sequential numbers based on cell value start with D9 and end with D7 (30 years term) and I would like to calculate in range Q3:V14. If I change D7 value to 10 years, in range Q3:V14 should count only 10 years and stop. See my attached XL2BB file. Thank you so much for your help...
  18. V

    VBA to find my headers and use them instead of range

    Hi, I have a spreadsheet where the columns changed at times (more are added or some are deleted). It's too much work to edit the ranges in all my macros every time. Is there a way for the VBA to figure out what column Q certain header is in and adjust the letters in the range accordingly? I...
  19. airforceone

    Error in computed Subtotal in Range

    hi again, I'm using set of VBA but does not compute the range properly! what seems to be the problem? i shall implement it in a loop sequence but the second computation is a bit off Range("A2:M" & LastRow).AutoFilter 1, "=" & "*DAMAGE TO PROPERTY" Range("B10") =...
  20. J

    Help modifying an existing macro to remove all of the "fixed" ranges in it

    I have taken over a project that someone previously developed the macros for. I would prefer it to work regardless of the dataset being used, but the person that developed it used mostly "fixed" ranges and I would prefer that it determines the range based on the data set. The beginning of the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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