named ranges

I am trying to sum a column using multiple variables in named ranges. So far i have only been able to get the formula to work using one or a few of the criteria. I started with this but it's not working. "=SUM(SUMIFS(Amount,Dept,{"Boston","Atlanta"},PartNo,{"PYFO","PYRH"}))". Below is a...

Hello Just to start off I used an indirect function to create a named range. https://dc2.safesync.com/DzVrPJm/NamedRanges.xlsx?a=SqhACDyeGNo I am having problems with named ranges where I am referencing a cell with the name of a named range via the indirect function but it is not picking it...

Anyone know how to do this?

Good morning all- I'm sure the answer is staring at me in the face, but I've wasted an entire day trying every syntax under the sun. I've also read through many similar posts, but none of the solutions seem to work for my situation. Background: I'm running a macro on a rather lengthy...

I've been trying to get this one working for a few days now but Named Ranges in VBA are being a total pain! I'm sure I'm missing something simple but I am still new to VBA and Excel and just can't figure it out. I have a sheet with test cases. A test case will consist of a title (first row)...

I am trying to change some range names on different sheets so I can do this faster than doing it manually. I have about 30 ranges for each sheet and they are all named Prop___ i.e. Prop1, Prop2, PropLAE1, PropSUB1... and I want to change them to CovA___. I need to do this for 5 different sheets...

Hi, I need help with building a vba script that would copy & paste-append all of my data from their defined "Named ranges" from one workbook to a new workbook. The workbook where I'm copying from has multiple worksheets and they each have their own set of data with their own named ranges...

Hi All, I have 52 named ranges that I wish to loop through in a vba routine ("Week1", "Week2", .... up to "Week52") I thought I could loop through all the "Week" ranges as follows: ============ For cloop = 1 To 52 weekrange = "Week" & cloop Range(weekrange).Select ============= However I get...

Hi, Can anyone help? I am trying to replicate a rather large worksheet in a new workbook. I need it to be identical in every way. I have copied the formulae by replacing "=" with "zz" then doing the reverse once pasted into the new book. This way the cells don't refernce the old workbook...

Hi, I have 50+ named ranges in a file. All ranges have names begin with the same three characters "KLM_XXXXX". How can i replace the first three characters "KLM" with "TIY", so all names in the file become "TIY_XXXXX"? Thanks, Commer

Hi all I am creating a dashboard - I started by creating combo box which was linked to a named range. I had no trouble creating the input range using a name in the format control dialog box of the combo box - pressed F3 and the list of names came up. The combo box has stopped working now -...

I'm writing my first "advanced" VBA code to move Named Ranges from Excel to Access. The Named Ranges are named the same as the Access Database field names. When I run my code, I receive the following error: "Object required". When I click "Debug", the debugger highlights DoCmd.RunSQL strSql...

I'm using Excel 2010 in Win XP. I have a named range that consists of selected concatenated rows from a larger spreadsheet. This list of rows is currently 116 but may increase or decrease based on the source data. I’m okay with this part.</SPAN></SPAN> I want my macro to go to the first row...

Dear All, I would like to use VBA to create named ranges from an extensive table, but i dont know how to write this specific code. The names to be used as the name for the named ranges are in row6, starting at column B onwards to the right. The data that should be in the range is varying in...

I'm trying to create Named excel ranges for one column with different row ranges based on the month in my case. Is there any way to do this from a cell range selection. So in my case Column B is where are the names of the ranges, and column C is the ranges itself. It takes a long time manually...

I have a named range in my workbook that is a constant value (Cratio=2.3755799). I want to refer to this value in my macro in a formula and then copy the answer of that formula back into the workbook. There are two ways that I have referred to this value and both are causing a 1004 error. They...

Apparently named ranges does not allow you to change the data using code instead you need to type in the new observations. Consider this: 1) Download the two files; Merg.xlsm and Australia - Close.xlsm to your desktop...

Hi Everyone, Currently using Office 2010, Windows 7 I'm looking for code that will clear only the cells in named range [TOT_TIME1] if the cells (same row) in named range [CAT1] are empty. I've tried the code below, but keep getting a "Type Mismatch" error. If [CAT1].Value = "" Then...

Hi All, Excel 2007 I'm preparing quite a complex weekly report and so I'm making use of dynamic charts based on a number of named ranges. Is there anyway to avoid having to create a named range for each and every series? This is proving somewhat tedious with certain types of chart, such as...

For some reason, the below snippet of code inserts a formula where the lookup value for the match functions actually refers to cell RC1, rather than the first column of the sheet and the row of the active cell. Does anyone know why this code would do this? I think it has something to do with the...