ranges

Suppose I want to show the names of various named ranges in a table. In this table, for example, I have assigned the name "Price" to Column C and "Quan" to Column D. I would like to put some expression, like "=RangeName(C:C)", into C6 and D6 that would show those names and would change if I...

Bonjour guys, hope you can help me with the below? I have this code below working for one given range (e.g. For Each A In Range("AE4:AE500") but as soon as I try adding more ranges to loop through, it gets stuck. any idea why? the code needs to check all ranges and only if all ranges are...

Hello All, Seeking some assistance, thanks in advance to anyone that can assist ! I placed 5x Radio Buttons to use for filtering the ranges of data i have. Range1 = 14-33 Range2 = 37-56 Range3 = 60-79 Range4 = 83-102 I also have a header range of 1-13 which must always be visible. When i...

Hi, i am trying to produce a spreadsheet that allows me to view how many items someone has sold per month. i am using the below formula but it doesnt seem to be working. if i take the date ranges out then if works but it gives the overall sales the person has had. i basically just want to add...

So, I have an excel sheet that tracks events that are booked for a certain date (Range = eventdate), and then payments (Ranges = payment1, payment2, payment3, payment4) are logged at certain correlating dates (Ranges = date1, date2, date3, date4). I have a formula that sums all deposits within a...

Hey excel Gurus, How do you combine 2 different ranges together with a With statement. With Range("A2:A1000" & "U1:FO1") is the above correct? thank you.

My array formula below works BUT, I think I need to apply maybe an INDIRECT function to stop the ranges from moving when I add a new row to my data set. Can anyone help? {=IFERROR(INDEX('EIRF Tracker '!$N$9:$N$2000,MODE(IF('EIRF Tracker '!$G$9:$G$2000="Injury",IF('EIRF Tracker...

Hi. I have this string that represents rows and row ranges separated by comma. str = "1,3,6:8,11:12" I want to join those rows in a single range variable (rng). I'm trying with this loop but the issue is initially rng is nothing and the "Union("nothing", Rows(s(0)))" gives error...

I have a list of numeric values in Column F to look up. I am trying to see if the value in each row of column F is valid in ranges in columns J-K and if so, return the value in column L for that row into column G. If the value is not found in any of the ranges in columns J-K, return an error...

Hi I have a table like the one below. I inserted a table (Insert-->Table). Now I understand (thanks for you help). This table have these ranges Table1[name] Table1[store] Table1[item] Table1[price] What is the benefit of using these ranges rather than I create my own ranges for example I...

Hello, I want to copy the ranges from Workbook_A Sheet(1) into the exact same cells of Workbook_B Sheet(1). Why won't this work and what is the best way to do that please? Windows("Workbook_A").Sheets(1).Range("P4:R7,N22:N47, AC4:AE7,AA22:AA47, AP4:AR7,AN22:AN47, BC4:BE7,BA22:BA47...

I want use macros to create different names for different ranges I have made (about 81 in total). The names vary slightly, for example one is called "Numbers_Left_G3" and another is "Numbers_Left_H5". The names depend on the cell above the range for example the former would have a cell above it...

Hi guys. I have an extremely large excel workbook that we use to do all of our client quotes, and as it's a document that has evolved over the years, there's loads of data and 'stuff' on it like Named ranges, references etc etc that must surely be causing my continuous crashing issues. Trouble...

Hi Folks Maybe you can help me. My code works fine as long as I select ranges that have the same number of columns. I use an application input box to capture the ranges (several ranges of various sizes) by using the control and left mouse button. It traps the addresses f the multiple ranges...

So I have some code that I have written referencing arrays, named ranges, and ranges. I have taken the workbook and re-designed it to be table based. I figure I will have to re-write the VBA code to reference the table objects instead of the ranges, right? Is there a simple way to do this or...

All, Trying to make so graphs with dynamic ranges using name manager. should be easy but I am missing something. I could fill all blanks In with 0 and it works but not without it. Here is what I have column B is a date June 2018- now and it always grows with each new day Column G-U is a...

Hi, I have set various ranges to be protected so only specific users can edit the ranges. Should they not be set to allow, they will be requested to enter a password. This all appears fine, however even without the sheet protected, and me having allow rights, the cursor will not enter the ranges...

Hello... I'm hoping this post will be understandable.... I have a problem regarding pasting rows from one workbook to another, where I want the pasted row to be become a part of a table with autofilled formulas in the end of the table. However, I have stumpled upon a problem, which I cannot...

Hi Everyone, My apologies in advance if this has already been answered; my searching has proven fruitless! I am attempting to export different ranges of the same sheet as separate pages of a single pdf document. What I am after is: Page 1 of the pdf: With ActiveSheet.PageSetup...

Hi All, I appreciate the time you will take in helping me address this issue. I have been at this for hours but cant figure it out. I have a sheet (Cert Responses) that is auto populated from survey responses. The cell ranges are A:BO All I am trying to do is copy values starting in A:K and L:Q...