range values

  1. F

    Grouping Values for a Macro?

    I'm beginning to learn to code in Excel, and I have a question about grouping items. I have about 100 different "types" of items that are separated into about 5 groups based on how I describe the item. I created a user form that allows you to choose the item from a tiered drop down list and...
  2. G

    Move non-blank values in a range to the top rows (VBA)

    Hello all, What I have is a small range with 5 rows and 2 columns. What I would like to do is turn this: <tbody> Deposit A 100.00 x x x x Deposit B 200.00 Deposit C 300.00 </tbody> Into this: <tbody> Deposit A 100.00 Deposit B 200.00 Deposit C 300.00 x x x x...
  3. C

    write range value to a cell

    Hi, I would like to write the value of a range I've selected to a particular cell. Can't seem to get that to work. Tried Valrange1 = Range("A" & s5row & ":A" & drow).Value, and then Cells(arow, 48) = Valrange1, but that only got me the first value in the range. Thought perhaps I needed DIM...
  4. A

    Assigning a specific range a value.

    Hello- I've looked through the forum (as well as google) and can't seem to find exactly what i'm looking for. I am looking to assign 3 different ranges different values i.e.- 1-6= -100, 7-8=0, and 9-10= 100. I then want to be able to use the end results to calculate an average. For Example 1...
  5. O

    Delete rows based on range of values found in Column A

    Hi Guys, I'm SO new to this, I don't even really understand how to put macros into the Excel coding section. :confused: I want to delete all the rows that show anything BUT a value between 300 and 400 in column A. I was trying to modify some of the other 'delete row' codes that have been...
  6. L

    Editing a Range from a value

    OK this is what i'm trying to do in a VBA macro: I have a value=4 on my cell B1. What i'm trying to do is putting this value inside my formula: COUNTA(A1:A4) so, if i change my B1 value the formula should change: B1=5 --> COUNTA(A1:A5) B1=9 --> COUNTA(A1:A9) B1=5000 --> COUNTA(A1:A5000)...

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