defined range

Hi, How can you extract the entire sheet data from a closed external workbook whereby the path name of the external workbook is mentioned in a cell in the open workbook? I guess you need VBA for this?

Hi, I have a listFiles named range to return a list of files of a specific folder into Excel. I use the following formula: =IFERROR(INDEX(listFiles,ROW()-ROW(A$2)),"") I was wondering if there is a non-VBA solution to automatically/live update the files list in the Excel named range whenever a...

I am trying to create a dynamic range that expands with new columns added. I created a defined name called ("DynamicCompList") and the range for this is D7:R57. When I enter information into S7, I want the range to expand to D7:S57. My data in the range has some blanks that need to stay. I tried...

I have a named range on sheet Competitor Comparison Data called “CCData”. I would like to add a new column to the end of the table every time I press a button. With each button press, a new column is added to the end of the range and is then included in the named range. The new column should...

I have a data entry area that is a defined range ("Data_Entry_Defined_Range") on a sheet called Data Entry Sheet that allows users to input data which then feeds over to a separate sheet (Report Sheet) with a defined range called ("Report_Defined_Range"). The report sheet is used to provide a...

I am lost, after reading oodles of suggestions on forums, I still don't understand why this code does not work: Code: Private Sub UserForm_Initialize() Me.ComboBoxService.List = Worksheets("LookupList").Range("ChartOfAccounts").Value End Sub My named range ChartOfAccounts is refers to...

Hello, everyone. I am trying to delete a named range and then delete the defined name also, so that my name manager is not full of old names. I recorded my actions while trying to delete a range called "Area2." The code that was recorded was: Sub Delete_Named_Range()...