named

Need excel gurus to help spot what's going on here. I have a named range that has a value for each of 10 periods. I'm using a Large/Countif formula to identify from other IF statement criteria, which period in named range would be captured for the table I have the formula in. My forumla works...

I'm new to VBA in excel and I borrowed this code from a previous thread that has worked well. It takes each value from column B in my main tab and creates a named tab with the format of the CONTROL tab and hyperlinks it in the original tab. My problem is that each tab, although correctly named...

I am trying to use a named range as the source of items for my listbox. This line creates the named range. It's in a standard module in my workbook. Workbooks("Sports17.xlsm").Names.Add Name:="data_file_list", RefersTo:="=OFFSET('[" & wb_sched.Name & "]" & temp_ws.Name & "'!$B$1,1,0,count('[" &...

I have a "Master" workbook and worksheets in it. Sometime I have two a worksheet tab named "Helper" and "Summary", but sometime I have three worksheets in it (like "Analyze", "Helper" and "Summary"). In the 'Temp' folder I have between 80 and 100 workbooks (all depends on the current month). I...

Unfortunately I am requesting a bit more help in learning Excel please. I have Sheet2 set up as a table that I want to load values from. I have 'declared', in the name box, names for each cell in sheet2. For example cell A5 is named 'CoinName1', cell A6 is named 'WebSite1', cell B5 is named...

Hi all - I have a worksheet that contains about 20 WORKSHEET scoped named ranges. Normally, when I delete a sheet with worksheet level named ranges, the named ranges are automatically removed. When I delete this particular sheet - the named ranges are still there - but they are turned into...

Hello, I have a workbook which has a named ranged which contains the full path to a number of Excel workbooks. I'm trying to put a macro together that can pull data (either by opening in each of the files in the background, copying and pasting and then closing the file OR using the OLEBD or...

Hi, i am trying to define a named range that excludes any blank cells. the named range though is across columns. the range is D11:IS11. I wanted to then use a DV list box to link to the named range. i have found plenty of examples that will do this in a column, how can i do it in one row...

Hi, I have a workbook 'workbook A' which contains the worksheet 'Datasheet'. Datasheet contains all data validation drop-down lists in this workbook. I would like to replace 'Datasheet' with a sheet from another workbook - 'workbook B' - also named 'Datasheet'. Is it possible to do this...

hi when using named ranges in vba....i found that you dont necessarily need to refer to the worksheet e.g let's say i have named range "desk" in the tab "A" usually in VBA i can just do range("desk").copy but for this one particular file, it doesn't work...i actually need to do this...

Hi I have a worksheet named "Required Data". In column A is a variable range of numbers (1,2,3,etc) and for each number there is a corresponding worksheet (named 1,2,3 etc). I need to copy the data in columns D:M and paste it in the 1st empty row of the corresponding worksheet e.g if A2 is 1...

Thanks in advance for any suggestions which I will give feedback. My actual file/case is much larger and entails a much larger amount of cells, but I have simplified it here. I have my cells NameRanged and I would like to copy a formula which includes the name ranges, but it remains static...

Hello, I would like to reference a named range in another workbook in my data validation drop down list, but I am having difficulty. The external workbook containing the named range is 2019 COA.xls The named range in the workbook that I want to reference is Revenue_Categories I tried several...

Hi Guys, I have 2 tables one named 'Steve' and the Other named 'Dave'. Is there a way to use VBA to clear the contents of both tables but leave the formulas in columns R,S,T,U,V. At the moment i just select all rows from row 3 down (leaving the heading and row 2) and delete . I then paste...

Hi, I have an IFS formula thus: =COUNTIFS(Orders!$V:$V,$K$4,Orders!$H:$H,I7,Orders!$G:$G,"unfulfilled",Orders!$E:$E,"<43566") where 43566 is the serial number of a cut-off date. This date is however regularly changing. I have created a named range, Order_Cuttoff_Date and put the date in...

Hi guys, I have a dropdown list on Sheet 1, cell A1 There are many tables on sheet 2, that are named ranges. If I select a value from the dropdown list, then the matching named range on Sheet 2 must be displayed on Sheet 1 cell A3. Any solution is appreciated. Cheers Owen

Hi all, I am updating around 90 workbooks for year end by adding an extra named range to an existing formula I will be doing this by looping through all of the workbooks to add the 18/19 spend in year to 15/16 16/17 17/18 Range("HRPreviousYearsSpend").Select ActiveCell.Replace...

Hi can anyone help? I have some Data in Range("A5:H5") and a named Range("A5:H11") I get new set of results in Range ("A3:H3") after filtering some Data and then transpose the results into the first column of my named Range ("A5:A11") using the following code Range("A5").Resize(7, 1).Value =...

Hi We've had a weird problem where excel seems to create hundreds of random named ranges in files which have NO named ranges. It's only happened three times and all of those times it happened on files which were linked to other files but it also doesn't always happen so I am not sure what's...