About 1,938,770 results (2,123 milliseconds)
Phantom External File Links, how can I break them?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/hBVji035hqo name doesn't exist sums the values in the range named "Hardware" on Sheet1, ... The find links vba code recommended by microsoft does not even run properly ...
When exporting a SpreadSheet with data validation to Excel Sheet ...
https://support.google.com/docs/thread/143553939/when-exporting-a-spreadsheet-with-data-validation-to-excel-sheet-data-validations-are-removed?hl=en Jan 2, 2022 ... ... Named Ranges". A formula written in Excel using Named Ranges will not work in Google Sheets cause a lot of times thos named ranges in Excel ...
Spreadsheet Service | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet Dec 9, 2024 ... Create, access and modify named ranges in a spreadsheet ... Adds a parameter, or if the parameter with the name exists, updates its source cell ...
Nightmare on ListNumbering Street
https://groups.google.com/g/microsoft.public.word.numbering/c/6vu34ZQW8NE > a different name if the "HeadingTemplate" List Template happens to exist > ... Then I use the name (which, despite the ambiguous VBA Help, John N showed ...
Beyond Excel - List Worksheets/Named Ranges in Closed Excel ...
https://sites.google.com/site/beyondexcel/home/about/project-updates/listworksheetsnamedrangesinclosedexcelworkbookswado Dec 8, 2013 ... Worksheets and named ranges are recognized by ADO, OLEDB, ODBC as data sources for SQL. We can list those datasources using ADO's OpenSchema ...
Is it possible to sort Google sheets if it has protected ranges in it ...
https://support.google.com/docs/thread/10084409/is-it-possible-to-sort-google-sheets-if-it-has-protected-ranges-in-it?hl=en Jul 17, 2019 ... I know that in excel you can filter options on a protected sheet. Is ... You can use VBA (record macros etc) but that means if someone ...
Inserting a row into excel file
https://groups.google.com/g/python-excel/c/OIS2_F5EDR4 not exist. I've been using xlrd to do all of the searching required, but it seems that an xlrd workbook is not compatible with an xlwt workbook
vba macro to google sheets - Google Docs Editors Community
https://support.google.com/docs/thread/10694392/vba-macro-to-google-sheets?hl=en Jul 26, 2019 ... I'm trying to convert some Macros from an inventory sheet in excel over to google sheets so it can be web based.
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range Access and modify spreadsheet ranges. A range can be a single cell in a sheet or a group of adjacent cells in a sheet.
putting data into a PDF document
https://groups.google.com/g/comp.databases.ms-access/c/dOAbTam1y_E This post relates to Excel, but the VBA would work in Access as well. https://www.excelforum.com/excel-programming-vba ... ActiveSheet.Range("D" & row_number) = ...
Beyond Excel - Parameterized Power Query
https://sites.google.com/site/beyondexcel/home/powerquerysnippets/parameterized-power-query List Worksheets/Named Ranges in Closed Excel Workbooks ... What can VBA do? Variables and Naming · Parameters · Template · Error Handling · Workbooks · Range ...
How to get last row using Excel DNA and C#
https://groups.google.com/g/exceldna/c/Pm9DDkceVIc May 5, 2017 ... Excel.Worksheets["Reference"].Range ... cs(2,35) : error CS0234: The type or namespace name 'Forms' does not exist in the namespace 'System.
Beyond Excel - Range Structure
https://sites.google.com/site/beyondexcel/home/vba-coding/range-object/range-structure Name Excel's four structural elements of ranges. Access cells by Index or Row and Column numbers. Access cells of a certain type within a range. Loop through ...
Lookup value across multiple sheets and return sheet name ...
https://support.google.com/docs/thread/293291880/lookup-value-across-multiple-sheets-and-return-sheet-name?hl=en Aug 28, 2024 ... ... cell only the name of the sheet in which that value is present. Details. Sheets,Microsoft Windows,Personal use. Locked. Informational ...
ExcelDNA and Microsoft.Office.Interop.Excel
https://groups.google.com/g/exceldna/c/cGaa-X5vlE8 Nov 28, 2017 ... The purpose is to migrate from VBA code to XLL (C#) in order to protect it. My XLL functions work with WorkBook, WorkSheet, Range, Cells (value, ...
INDIRECT.EXT function, PULL function
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/l9ObQ9ku6Bk INDIRECT.EXT successfully returns the VALUE (CONTENTS) in the target cell from an open or closed workbook and works for SUM() etc., but not an address range.
Beyond Excel - Module: Dynamic Ranges
https://sites.google.com/site/beyondexcel/home/excel-library/module-dynamic-ranges "Module" is a name Microsoft uses to refer to a package of LAMBDAs. I package related LAMBDAs into modules so we can download several LAMBDAs at once. If a ...
I'm getting #ref when deleting rows. Is there a way to avoid this ...
https://support.google.com/docs/thread/84417645/i-m-getting-ref-when-deleting-rows-is-there-a-way-to-avoid-this?hl=en Nov 21, 2020 ... I'm not too familiar with excel or google sheets. Is there ... The solution is to use Arrayformulas that refer to a RANGE of cells/rows.
Beyond Excel - Collections and Dictionaries
https://sites.google.com/site/beyondexcel/home/vba-coding/collections-and-dictionaries Dictionaries are perfect for creating unique lists in VBA using the dictionary's "silent add" behavior. Function GetDistinct(ByVal oTarget as Range) as Variant.
Auto Fill Text in Google Forms Spreadsheet With Value from Another ...
https://support.google.com/docs/thread/153202065/auto-fill-text-in-google-forms-spreadsheet-with-value-from-another-column-if-blank?hl=en Mar 2, 2022 ... I am somewhat tech-savvy and have done formulas in MS Excel, but am a Google formula newbie. Appreciate any help I can get! Details. Sheets ...