range

  1. F

    Test for non contiguous range

    How you check if non contiguous selection is on more than 1 row and more than 1 column. In this case, don't continue macro. In image below, grey cells represent selection. Tried to test using below but don't get the expected answer. MyRange.Rows.Count MyRange.Columns.Count
  2. C

    For Next loop skipping blank cell, but indexes past next cell

    All, I decided to make my first post a fun one. I am working on some code to essentially find any cell in a given range that has text and append .01 to the end of it, but need to skip any cell that is blank or null. Currently this is working ok, except when it skips a blank cell lets say row...
  3. J

    VBA to compare rows in two different sheets, if match highlight cell

    Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...
  4. A

    Find and Replace Value in List Named Range Reference

    I am making a bracket for basketball teams by region. I select the winner of the game based on a list referencing the named ranges you see pasted below. I pull data from multiple web queries into each regional bracket and have many formulas. Because of this, its quicker to copy the sheet and...
  5. C

    Subscript out of range error

    I made a small change to simply skip/remove F4, F20:F24, F94:F101 from the original working rangeBudget as shown below. Original rangeBudget array on Line 43 no error, works. Modified rangeBudget array on Line 39 gives error. Range F81:F:90 on the Months sheet is the last highlighted range...
  6. R

    Lookup 2nd last value in a range

    Hi, I have a formula that looks up the last value in a range. This formula is =LOOKUP(2,1/(L2:BI2<>""),L2:BI2) I would like another formula to look up the 2nd last value in a range. Could someone supply this for me please? Thanks in advance
  7. R

    Multiply IFS Function

    Hi, I am wondering if there is a Multiply function that replaces the SUMIFS? Basically the formula will look for 3 critertias and will return 4 different values. In a SUMIFS formula it will add the values however I need each of the 4 values to multiply. Example 2, 3, 4, 5 in a SUMIFS will return...
  8. G

    Range Variable show value of it in basic format

    Hi everyone, Is there any possibilty to simply write value of range variable into cell? See my code Dim SpecifiedRange As Range Set SpecifiedRange = Application.InputBox("Označ myšou v exeli z 3D rozsah kopírovania pre 1 kartu", Type:=8) Dim Range1K As String Range1K =...
  9. P

    VBA worksheet change when copy paste multiple range

    Hello everyone, I'm back here for help again so please bear with me. I have a vba code that is triggered when there is a change in a range of cells. It works well if the changes are done cells by cells but i get an error in the case if i were to copy and paste for multiple cells in one go. I...
  10. R

    % Percentage Formula for a random range

    Hi, I am sure this may be availabe in simple math but I need a formula for it. Say I have a range of numebrs where 1 is the lowest and 73 is the highest, with all other numebrs in the range. How to i streth this both ways so that 1 becomes 0% and 73 becomes 100%? Which means 37 may be in and...
  11. O

    Dividing a sumifs() statement by another sumifs() statement - Problem: Second sumifs() not recognizing valid ranges.

    Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...
  12. T

    Range with Name Manager

    In VBA, I have a multi column range on one sheet (DocMgr!$Q$8:$V$27) where, on another sheet, I need to find the max value in the second column if the first columns meets a certain condition. The way I found to do this is to write an array formula to a cell and then get the resulting value like...
  13. S

    Find list of words in range for array formula

    I have a spreadsheet that I am trying to populate by using an array formula. Right now, I have a formula that looks in a range and identifies if the word "Spouse" is within it. However, I would like to update the formula to search for "Spouse" & "Ex-Spouse" within the same range, but my current...
  14. U

    range help!

    Hi there, I have a worksheet, that has data, but want to start the capture on line 9. I tried to use the below to find the last row for S9, but seems when running this, it only copies/pastes F9. I would like it to continue until the last row of S9:end. Note that S9 starts with values, then has...
  15. N

    Trouble expanding cell range in a vLookup in a macro

    Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...
  16. N

    2 QUESTIONS - DATE SEARCH AND OUTLOOK CALENDER

    Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...
  17. Z

    VBA: Select Range in Current Week

    Hello, I'm trying to figure out how I can select a range based on a date within the current week. Example of selection… The order I'm trying to step through is the following: 1. Declare Friday as a variable to store the date using a formula: =TODAY()-WEEKDAY(TODAY(),16)+7 As of today...
  18. N

    Runtime error -2147417848 (80010108) method value of the object range failed

    Hi I am trying to save the data into the MainInventory but unable to do as I keep getting this error When my sheet is empty and insert the second row as my first row is headers row the data is inserts fine everything works fine but as i enter the third row this pops ups and my vba closes and...
  19. H

    Group and UnGroup columns based on user input of a current date

    I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...
  20. M

    Specific columns from auto filter range - VBA

    Is there a way to only copy certain columns from an auto filter? With the below example the active sheet has 8 columns of data G, L, P, R, S, T, W, AB (other columns have been hidden) When I copy the data, I don’t want to copy column W & AB so that only 6 columns of data will be moved to...

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