1. G

    VBA Select range using Find method and variables

    Hi All, I have a set of values in Column A of a worksheet named "Data". Cell A1 has the value as "Description" Cell A9 is blank Cell A10 has the value as "Team Total" The current active cell is D100 I would like to use the VBA "Cells.Find(What:="Description" statement to get to A1 from...
  2. J

    inserting pictures through vba, but the position and range doesn't match

    Hi, i made a macro by clicking the cell and inserting a picture image. But, the vba range and the sheet range doesn't match. ex. i want to insert a picture in cell b6 but it seems the picture inserts in between b5 and b6. this is my code below Private Sub Worksheet_BeforeDoubleClick(ByVal...
  3. 1

    Selecting range from bottom visual cell containing a value in a column upwards

    Hi all, I'm hoping someone is able to advise if there is a formaula able to select a range of cells starting from the very bottom cell in a column, which contains a value, and is visible within a filtered column, up 25 cells. This is so that a formula I have only looks in that range, which is...
  4. M

    Export a range to pdf

    Afternoon I am looking to export a number of ranges to one single PDF but one of the ranges is a variable range. The ranges I want to export are: A1:C12 A13:C26 A27:C38 A42:C72 A73:C95 G161: the last cell with a text in it located in Column K the file name is: thisworkbook.path & “Reports” &...
  5. D

    VBA one cell returns date of last time another cell was edited

    Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...
  6. U

    VBA FormulaArray Syntax/AutoFill/Set Ranges

    Hi all I am trying to do a few things here with VBA: Here's the source Worksheet named MoCMatrix ABCDEFGHIJKLMNOPQRSTUVW1HELPER ROW > Structural Integrity-MoCStructural Integrity-Substantiation DocumentStructural Integrity-StatementFlammability & Smoke-MoCFlammability & Smoke-Substantiation...
  7. S

    Email range as a email to SMS

    Hello, I am looking to create a macro that selects a specific range (2 columns) and emails it to phone numbers (e.g. 5551112222@vtext.com). The range looks something like this: Apples 5% Oranges 4% Bananas 4% Tomatos 3% Other 50% The issue i'm running into is the fact that it needs...
  8. J

    IF and CountIf

    This is my formula =IF(COUNTIF(B$6:B$21,"*"&$A6&"*"),"","Free"). Instead of showing nothing if CountIf returns 1, I'd like to show the value of the cell. Because it is a range, I'm not sure how to show just the value of the cell where it matches my condition. Kindly advise. Thanks a lot!
  9. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  10. O

    Dividing a Defined Range by a Defined Range

    Hello, Been trying to figure this out for a few days now, and starting to drive me crazy. Sub Annualize() Dim WB As Workbook Set WB = ThisWorkbook Dim WS As Worksheet Set WS = WB.ThisWorksheet Dim Range1 As Range Set Range1 = WS.Range("B2:B4") Dim Range2 As Range Set Range2 =...
  11. M

    VBA: Find and Group All Occurrences of Value, Run Sub, Move to Next Group

    Hi, I need some help getting started on a code. I have a range ("B4:B") of variables that are related by the first four characters (the year). Currently an input box will appear asking which year to run the code in, and the default value is based on the left four characters of the active cell...
  12. S

    Take numbers in a list and convert to ranges for consecutive numbers

    I have a problem that I'm sure there is a formula that can perform this function. I have a list of numbers, some are consecutive and some are outliers. I need to take this data and create a "From" "To" column on those numbers that are consecutive. Below is an example of the data that I have...
  13. A

    conditional range

    I need to create a range between B5:M5 that is defined by the location of P1 (phase 1) and P2 (phase 2) in Row 4. The range should begin one column to the right and one row down from P1 and end at the cell one column to the left and one row down from P2. P1 and P2 are both movable and so...
  14. MikeMcCollister

    How do I get a sub-range in VBA

    I have a table called "MainChecking". I can get the range for a column of the table by using the .Range function. Now I want a subset of that range but I can't figure it out. For example, this range may have 500 rows in it with just one column. I want to get a range that will be from row 229 to...
  15. A

    Method Clear Contents of Object Range Failed

    Hi I have the following simple code, never had an issue with it before but all of a sudden I am getting the "Method Clear Contents of Object Range Failed" run time error. From what I have read this isnt so much an error with the code but more to do with the system is that correct? If anyone...
  16. S

    VBA - send email with multiple ranges in body with 'If Target.Value'

    Hi, I am trying to have a VBA to send out an email if when several rows which have a special character in column A, The VBA I have to add this character is : (wingding font for the check symbol) Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.CountLarge > 1 Then Exit Sub...
  17. D

    Replace word loop

    Hello, I am trying to build some macro that would replace some word from a table, based on a list of words, and paste each time the table one after the other. Example: Cat1 10 Replace Cat Horse1 10 Cat2 20 With Horse Horse2 20 Cat3 30 Cow Horse3 30 Cat4 40 Dog...
  18. lockarde

    Sort range based on value

    Good morning all, I have an issue with a spreadsheet I use to track job details. Ideally, these details are supposed to be entered as they come in, but sometimes people wait, and suddenly there are details from several days or even weeks past. Is there a way to sort all of these details by...
  19. D

    Highlight cells with Conditional Formatting using large range of values

    Hello all, this is my first post. I’m having an issue with Conditional Formatting. I work in a warehouse, and I am having issues in a certain section of the warehouse with items being split across several different stock locations rather than being consolidated into 1 or 2 locations. There is...
  20. L

    How to loop through cell to increment value on a different cell through VBA

    Hi I am trying to create a VBA script. I have Customer Number on Column A, Date on Column B and Seq on Column C. I start with Seq 1 for the first customer and date. If the next row has the same customer and the same date, I put seq 1 on column 1. On change of any date for the same customer...

Some videos you may like

This Week's Hot Topics