range values

I created this macro to count the number of rows starting from column B. Then I created a cycle to fill columns 3,4,5 and 6 with excel formulas. my problem is that the references should be relative and not absolute (b5,b6,b7 and c5, c6,c7...until the last line). I can't finish the macro. Can you...

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...

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...

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...

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...

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...

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)...