ranges

The formula below that is in W247 works correctly. You will notice if the lookup finds a value (the secondary VLOOKUP logis), that the formula returns the value in column 9. But if the value for column 9 is blank, then I want blank returned. Currently Excel is populating the value of "1/0/00" I...

So I have a userform that initializes with the following code. The comboboxes are named CB_AQUEOUS and CB_SOLDIS. I have ranges in Sheet1 that I source the lists from. But if the ranges change, I have to manually update the code. Is there a way I can simply do a *last row* on this? Is the...

I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up...

I have a value e.g 48 There are multiple ranges, and each range will correspond to a specific amount, example below: 11 to 20 --> 15 21 to 30 --> 25 31 to 40 --> 35 41 to 50 --> 45 I want to search for the value 45, so i need to check the multiple ranges to get that specific value on the...

I have two ranges: R1 and R2. They have same header How to combine them so R1 is on top and R2 is at the bottom to form a new combined range called "R"? Thanks

I need to change the formulas on several pages for several ranges, by adding an if statement that says if the result is greater than 100% then show 100% or else show the normal result of the formula. I'm not quite sure how to do it without breaking my back. Ranges are the same on all the pages i...

Hey all, Is there a way to make a macro recognize that a check mark has been checked? and if so what is it? I am trying to have a few check boxes select different ranges and a button copy those ranges and then paste them elsewhere. Thank you in advance.

Hello, I have one Worksheet (Sheet1)where a user enters three items: "FirstName", "LastName", "City" in B1 to B3 I would like to click a button to then take the three values and pastes into other worksheets in workbook. ie Sheet2 has a named range called "FirstName". VBA to look for...

I want to dynamically copy an unknown number of multiple ranges from one spreadsheet to another. The list of ranges is stored in a table in the "to" spreadsheet with the - ranges from in a list called "list_from" and the - ranges to in a list called "list_to" I want the variable...

Hi All, I have an excel spread sheet that summarises a Table of data, currently using the Sum(countifs()) functions to look up columns and Count the number of time specific Criteria are meet. two of the criteria are in the form of Arrays. i would like to change these to Named Ranges and...

In Tab 1 i have a list of individual 5-digit codes. Each code is a specific type of hospital procedure. In tab 2 I have a list of hospital procedures names and the ranges of 5-digit codes that fall into that procedure. The ranges are NOT continuous and have gaps in them. For example, one...

hello I have four named ranges tcd1, tcd2, tcd3 and tcd4 which are all hidden when user opens sheet What I would appreciate is vba code (if it's possible) when the user clicks macro button code checks tcd1,2,3 and 4 for their hidden/unhidden status and unhides one of the hidden named ranges...

I have never had this happen before in all my work with named ranges. I created some named ranges to reference INDEX() functions that are row specific in a table. For example: "=INDEX(A6Bals,LastRow)". The Named Range works fine until I close and reopen. When I reopen, all of my cells with...

Hello...My name is Robert, and I am a middle school math teacher who is almost finished completing modifications of his gradebook for the following school year. I am looking for a formula or macro that will delete objects such as pictures and text from cell ranges of multiple columns. I have a...

Hello! I'm studying VBA and actually trying to get a degree in programming so every chance I get to practice at work with code, I do so. I've come up with something I want to do, but can't get my head around HOW to do it. On Workbook 1 (called "Line" as an example), I would have 2 columns...

I am trying to create a tool that will allow you to paste a column of IP addresses and have each address searched for in a range of IP addresses. For each address found in a range then Excel returns "yes", otherwise "no" The table below is a sample of the pasted addresses (column F) To the...

Hi, I have a large number of named ranges and I want to run the same formula on all of them. It seems like I should be able to make a list of the named ranges and then run the formula on all of them but I can't get it to work...anyone? Thanks in advance. JFS

So this is one IP scenario I've searched high and low for and can't believe I'm this "lucky" to be the only one looking for it. I have a long list of IP's (spanning across multiple c class or /24's) and it also has "ranges" in it and I'd like to have the ranges split out into single IP's...

Hi all, I've often used the following two lines of VBA to name column ranges based on text labels in the first row of a worksheet, and this has always been really useful when manipulating data. Set rangeToName = Worksheets("Sheet1").Range("A:BZ") rangeToName.CreateNames Top:=True...

Howdy folks! You've been my rock many times so I'm hoping someone here has a suggestion. Below is a sample of a spreadsheet with two small bits of data. Start Here is where we need to see if the RANGE of numbers covered by the Bates label columns are found in *ANY* of the values in SHEET 1...