#name error

Little bit complicated code I found somewhere here on the forum, but cant seem to re-find. That said, I want to use the very useful SMA function below (written by Bobby if I recall correctly?) and port it to work in the array calculations in vba, not in the sheet. My first hiccup is that it...

Hi, I have an issue with a colleague of mine. I have created a report for her which works fine on my laptop (Windows 10), and also my other colleagues laptop (also windows 10) however when I send it to her (Windows 7) she gets a #name? error in some of the SUMIF fields, however a majority of...

Hello! I'm having issues creating a named range in excel. Here's my Code in VBA: Public Sub Range_Very_Large() ActiveWorkbook.Names.Add Name:="very_large", _ RefersTo:="='UK WWTWs'!$B$334:$B$" & Sheets("Business Model").Range("F40") End Sub When I go into a cell on a sheet and put...

I've written a simple formula (below, i don't have excel 2013 with the =formulatext function) on a tab in a standalone model which i then need to drop into a large number of other models. The formula is written on the worksheet in the standalone model (not a module) and it works in the...

I have tried 2 different ways to find the Max value in a column based on 2 variables. You can see in example 2, I even tried to hard code the variable name instead of using the cell reference just to make sure it was not an issue with my validate fields in A@ and G2...

I've got a list of names, numbers, and identifiers. I have one sheet that is perfectly sorted(Sheet1), and one that is extremely jumbled(Sheet2). I need to sort the jumbled ones to be sorted. They're both very similar. The sorted one is sorted into multiple categories, such as Category A, B, C...

Hi, I have a control sheet with a number named ranges. A formula with one of these (which was previously working) is now coming up with a #NAME error. I know this means that it's not recognising the named range as legitimate, but I've tried all the usual things to resolve, and I still can't...