About 1,839,492 results (3,472 milliseconds)
Is there an efficient way to read named ranges from Excel into Python?
https://groups.google.com/g/openpyxl-users/c/OHwe9f4QnWc Jan 21, 2019 ... For a range of just 300 rows x 100 columns = 30,000 cells it takes more than 30min, which is frustrating since other programs can read those ...
Finding A Range Name
https://groups.google.com/g/exceldna/c/jgMGH-O33tA array of the names, and look for your range in there. Anyway - it looks like you can get the same information in ExcelDna that you get in VBA or Automation, ...
Data Validation List from a Dynamic Named Range on Another ...
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/PN0HmhFptKw/m/5xJmUIRPH38J Mar 23, 2010 ... ... VBA to the first sheet (without the lists) that lets me populate the cell with dependent data validation with multiple values per cell...
How to automatically change a sheet name to the text entered into ...
https://support.google.com/docs/thread/109495829/how-to-automatically-change-a-sheet-name-to-the-text-entered-into-merged-cells-on-a-different-sheet?hl=en May 11, 2021 ... I tried using VBA code (see below) that I found online and I got it to work when using a cell from the same sheet but I can't figure out how ...
Constructing Range Name calls with Concatenate
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/nO49g14HDus match a named range single cell value. All I see in the cell is the concatenated value, not the resolved range name cell value. I use a Y/N cell to turn it ...
IF statement can't return a NAMED RANGE
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/i2exIaNGbMw The way that the statement is written, I'm getting a #VALUE error when true. I'm sure it has to do with some limitation Excel has with returning a named range ...
Refering to Excel Range Names
https://groups.google.com/g/exceldna/c/CZ6Hy_X9xkw been able to see how to refer to excel range names. eg my VBA includes code that looks ... return ((ExcelReference)value).GetValue(); else return value ...
Read & write cell values | Google Sheets | Google for Developers
https://developers.google.com/sheets/api/guides/values Dec 19, 2024 ... A cell is a location at the intersection of a particular row and column, and might contain a data value. The Google Sheets API provides the ...
get the text string of a cell formula?
https://groups.google.com/g/exceldna/c/y1Y72WvVfmA Jun 19, 2023 ... It compiles, but Excel returns a #VALUE error at the string string strFormula line. ... Name="Cell",Description ="Cell containing formula.
Why this excel sheet is not working when I upload it to google sheets ...
https://support.google.com/docs/thread/2425399/why-this-excel-sheet-is-not-working-when-i-upload-it-to-google-sheets?hl=en Mar 14, 2019 ... ... named range in excel, and reproduce it in google: Google : Data ... To extract vba file from you excel file it is a task, if you cant ...
Set chart source data to a named range - how?
https://groups.google.com/g/microsoft.public.excel.charting/c/r_2G_Zc9eaQ Mar 21, 2002 ... that Excel changes the named range to its static address equivalent. Bummer. You can get around this two ways. The first is to define ...
Beyond Excel - Parameterized Power Query
https://sites.google.com/site/beyondexcel/home/powerquerysnippets/parameterized-power-query fncGetNameValue gets the first value it finds in the named range's RefersTo setting. If we have a named range called "Periods" we could get its value like so: ...
Best way to pass Ranges from Excel through ExcelDNA to DLL and ...
https://groups.google.com/g/exceldna/c/doJEPLzXeVQ Mar 5, 2012 ... You'll see the handling of the values retrieved from the Range is a bit messy, since Excel will return arrays that are 1-based, and the C# then ...
Getting color codes of font or background color from cell in google ...
https://support.google.com/docs/thread/147420647/getting-color-codes-of-font-or-background-color-from-cell-in-google-sheets?hl=en Jan 24, 2022 ... I set the =ColorCode_Font function in the name manager of excel. If you need the formula feel free to ask so i will try to translate it from ...
Using a drop down list to change values in the cell next to it - Google ...
https://support.google.com/docs/thread/221341359/using-a-drop-down-list-to-change-values-in-the-cell-next-to-it?hl=en Jun 17, 2023 ... I want to be able to select a name in a drop down box, and next to it show the correct value. I can achieve this with IFS, but I would need to copy/paste and ...
VBA to GAS: Transfer Data from one tab to another automatically ...
https://support.google.com/docs/thread/28567127/vba-to-gas-transfer-data-from-one-tab-to-another-automatically?hl=en Feb 12, 2020 ... Name = Range("C4"). Item = Range("C5"). Worksheets("sheet2").Select ... ActiveCell.Value = Name. ActiveCell.Offset(0, 1).Select. ActiveCell ...
Handling array formulae in ExcelDNA UDF
https://groups.google.com/g/exceldna/c/GyX1G_lxO5o Oct 21, 2016 ... In VBA I do get this result-array by myArray1 = Evaluate(Range("_myArrayformula1").Formula) - See example above. But in C# or with Excel-DNA I ...
I want to create a button in google sheets that changes values in ...
https://support.google.com/docs/thread/191191324/i-want-to-create-a-button-in-google-sheets-that-changes-values-in-other-cells-based-on-criteria?hl=en Dec 3, 2022 ... ... range.rowStart >= 2 && e.value == 'TRUE'). {. //get the customer name (in the column 1 to the left). var cust = sh.getRange(e.range.rowStart, e ...
CONVERT VBA TO GOOGLE SHEETS - Google Docs Editors ...
https://support.google.com/docs/thread/59768869/convert-vba-to-google-sheets?hl=en Jul 18, 2020 ... ... Value = form.Range("C2").Value. database.Range("C" & Last_Row).Value ... spreadsheet the hand entered expected results that you would like to get.
Excel Function not re-processing String variable?
https://groups.google.com/g/exceldna/c/qt_4dGMeTGM Jun 22, 2023 ... - use INDIRECT to get those cell values - combine the values into a ... Name="Cell",Description ="Cell containing formula.")] object ...