range

  1. J

    SUMIF with INT

    Hi, I have this table (its spanish so decimals are commas) I want it to add items as a new total in G66 if the integer in column a is the same as the reference number in A66, but it seems it wont work on a range. =SUMIF(A14:A58;INT(A14:A58)=A66;G14:G58) Thanks for the help
  2. V

    Check if values in a range are the same.

    Good day, Looking for any help on the following problem. Column A has variables. Column B marks the start and end of a range. Column C must display the variable, if variables in the range are all the same. If not "-". Not sure if this explanation if clear enough. Any help, thread or tutorial...
  3. R

    VBA: Macro to delete range runs normally, gives error 1004 if I click on a cell with data validation

    This is my first post here, so sorry if I made any mistakes (this forum has helped me a lot before tho, thanks!). I'm trying to make a macro that will delete everything within a range of cells, but I'm running into a weird issue. There's a couple of checkboxes and a picture that don't get...
  4. B

    Set Range = Worksheet.Range(Cells(..), Cells(..)) SYNTAX

    Hey Mr Excel Members I keep getting an error ("wrong number of arguments" or "method range failed for object _worksheet") on trying to add multiple different cells from different rows (row as long that can change) to a range. Dim TPsheet As Worksheet Set TPsheet =...
  5. B

    Divide Range in smaller Ranges based on Cell-Values

    Hey MR. Excel Members, I know the title sucks but let me explain as I think this is fairly easy but I cant manage to solve it. I have a table that looks like this: Now I want to loop through this table and set a range named "xvalues" to the B-column values for each platform (entry in column...
  6. E

    VBA Perform Autofill formula in specified column name/location

    Hello, I have a VBA macro that will insert a new column (titled updated col..) to the right of the specified column name. Then I use a VLOOKUP and autofill in the new column to provide the updated values. The column location of the updated column is variable/dynamic. How can I make the autofill...
  7. S

    How to add a condition to a macro If the name does not exist, continue to Next.

    I have a Macro that converts the table back to Range. The problem occurs if there is no table name in Sheet3. I need the macro to skip this step then and continue Sub ConvertTableToRange5() Dim rList As Range Dim ws As Worksheet ' Source - delete table Name...
  8. E

    Make Cell Range formattable while protected

    I'm looking to make cell range C9:C56 the only cells on the sheet where I can allow users to format the cell while protected and be able to change the cell colors in that range only to their liking. So far, with the given code below, all cells on the sheet are formattable while protected. From...
  9. J

    Footer Linked Range (Multiple Cells)

    I would like to be able to have a footer that is linked to a range on the same sheet (AL1:AM4). (If possible) Or if it is not able to, just a way to stack the cells and create multiple rows The Current code I created allows me to do this but it is in a single line. Example Private Sub...
  10. U

    Multiple Listboxes showing ranges from active sheets

    Hi Everyone, This is my First Ever Post: I am creating a user form that will function similarly to a school management system. One of the elements that are part of it is a Pupil Profile, which shows all information relating to the specific child. Currently, each pupil has its own sheet. When...
  11. B

    Average, Large, Date Range question

    Hello, I am calculating a weekly score for number of steps performed. I'm taking the top 5 days out of the 7 days in a week using this: =AVERAGE(LARGE($B$2:$B$8,{1,2,3,4,5})) The NO HOLIDAYS table in my spreadsheet is working perfectly. The HOLIDAYS table is just a copy of that table which...
  12. E

    Range of Objects Error

    I'm running into a Range of Objects Worksheet Failed Error for some reason and I cant understand why. All I did was add the following code to the set of ranges in the Target Range in the sheet code, and all of the sudden I'm having errors when entering text into the any of the cells within the...
  13. G

    Range VBA Errors

    I've got this range I'm trying to work with and do the following but I'm getting an error message for application or object-defined error. When I use the full range it seems to be the AB sections that are causing the problem. When I delete everything and just use the AB Range it works fine...
  14. M

    Sum from previous row, different column

    hi all, I was wondering if I could add from a previous row in a different column. from what I have pasted, for example the debit is add and the credit is subtract. in row 12 the credit(column G) would go into H, then the next row would either be debit or credit, whichever one it is would add or...
  15. E

    Highlight Row and Column on cell selection

    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple sets of ranges. Ranges are E9:DA56 and E59:DA106 where I would like it to be active. 2) Only highlight or outline the cells above the...
  16. A

    Get number of row in Range

    Hello, I am trying to write a Sub in which I need the number of rows in a Range which is input as a parameter of the Sub. I can't find the syntax to get the number of rows in the range. For other functions where the range is already known (in this case Range("A:A")) when writing, I've been...
  17. M

    Subrange of a range help

    I would like to capture the first 20 rows of the range described in the formula I have OFFSET('Market Returns'!$J$3:$O$249,0,L$1-1). I tried using index but I am getting reference errors. Thank you. The formula works otherwise.
  18. A

    Copy column to range

    Hello. I would like to copy a column to another worksheet when the header matches a string input. I have the code below: Sub find_col(name As String) Sheets("name").Range("A:A").Clear With Sheets("lot") .Activate For i = 1 To .UsedRange.Columns.count If Cells(1, i).value = name Then...
  19. P

    Select range based on time.

    I have data like the image below. I am trying to select a range from Cell B7 to Cell B908, Do Something, Select range B909 to B1807, Do Something, and continue this loop until I get to the last row of data. The cycle runs about 45sec each time, but there are always multiple instances of the time...
  20. J

    ClearContent in range instead of EntireRow row

    I need some help to fix this code to copy and clear content only in a range instead of copying and clearing the whole row. What the code does now, is that if column "I" is greater than column "J", in row 2-14, it copys the rows and PasteSpecial from row 16 and onwards. I want to copy only...

Watch MrExcel Video

This Week's Hot Topics

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
Top