About 1,156,524 results (3,003 milliseconds)
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 ... select the cell, Data Validation, Allow List, Source =OFFSET(Parks,1 ... I will also be adding more VBA to the first sheet (without the lists)
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 ... When your named range has changed, select the chart and run this macro. You could link this macro to a worksheet_change event, if you want ...
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 ... In Excel I have a VBA command ... Name = Range("C4"). Item = Range("C5"). Worksheets("sheet2").Select. Worksheets("sheet2").Range("B4").Select.
I need a script to clear certain cells in sheets when a button is ...
https://support.google.com/docs/thread/5809954/i-need-a-script-to-clear-certain-cells-in-sheets-when-a-button-is-pressed?hl=en May 9, 2019 ... Once I saved I then drew a crude button like image and assigned the macro to it by selecting assign script and then typing in the name I gave ...
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 ...
Macro to Copy Pivot Table Data to Another Worksheet in Same ...
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/KCIQJzf0GeE 'Name the sheet for the value in the column A field. NewSht.Name = NewSht.Range("A2").Value ... Cells.Select Selection.Copy Sheets("Sheet2").Select Sheets("Sheet2 ...
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 ...
Executing MS Excel through MS Access vba
https://groups.google.com/g/microsoft.public.access.formscoding/c/UWZ25GQ4IYs cell.Font.Name = "Arial" cell.Font.Bold = True cell.Interior.Color ... xlSheet.Cells(1, 1).Select 'Removes the selection 'Set the Margins, Headers ...
Dear all, What's the best practice to store the named range ...
https://groups.google.com/g/exceldna/c/U8qeOpHiuI8 I've done something very similar using hidden names as the link back to Excel and storing the query parameters and other table info in an object which is then ...
Re: Proper Way To Use InputBox In Absence of RefEdit?
https://groups.google.com/g/exceldna/c/O_kP1QzAQ28 > SelectedAddress = ExcelDnaUtil.Application.InputBox("Select your > desired cells.", , , , , , , 8) > If SelectedAddress Is Nothing Then > SelectionTest ...
Use macros and add-ons - Google Docs Editors Help
https://support.google.com/docs/answer/9331168?hl=en Use relative references: The macro will do tasks on the cell you select and its nearby cells. ... Microsoft Visual Basic for Applications does for Excel.
IsFunctionWizard
https://groups.google.com/g/exceldna/c/QdqkZPl5wQE/m/zsrKfekJBwAJ If I write UDF function in VBA, call FunctionWizard and choose cancel, the cell is cleared. ... name of function in the selected excel cell and the launches UDF.
Automate tasks in Google Sheets - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/7665004?hl=en&co=GENIE.Platform%3DDesktop Use relative references: The macro will do tasks on the cell you select and its nearby cells. ... Name the macro, create a custom shortcut, and click Save.
What's the correct way to indicate an "endless" range? - Google ...
https://support.google.com/docs/thread/118059590/what-s-the-correct-way-to-indicate-an-endless-range?hl=en Jul 21, 2021 ... All my searching just finds help pages that talk about selecting a range, I can't find how to indicate a range that extends as far as there is ...
Beyond Excel - Parameterized Power Query
https://sites.google.com/site/beyondexcel/home/powerquerysnippets/parameterized-power-query If you prefer names, use Excel's Name Manager to create a one or more names where each name refers to a cell holding a parameter. Tables. If you prefer tables, ...
Google Sheets Macros | Apps Script | Google for Developers
https://developers.google.com/apps-script/guides/sheets/macros Dec 19, 2024 ... ... macro name here; the name defaults to the name of the ... range of cells by first selecting the full range and then activating the macro.
Beyond Excel - SelRows()
https://sites.google.com/site/beyondexcel/home/about/project-updates/selrows Aug 15, 2014 ... Here is a nifty routine to select table rows based on multiple criteria which can include values as well as cell colors, font colors and ...
How do I make cell 'A1' the active cell in a sheets macro. - Google ...
https://support.google.com/docs/thread/8836894/how-do-i-make-cell-a1-the-active-cell-in-a-sheets-macro?hl=en Jun 27, 2019 ... Non of the suggested functions have worked. I need this because the offsets depend on this starting point. The macro name is: ...
excel - Copy/Paste not working when just one row of data filtered ...
http://feedproxy.google.com/~r/stackoverflow/JqJq/~3/SkzpTRzB7rA/copy-paste-not-working-when-just-one-row-of-data-filtered May 28, 2021 ... ... Name).CurrentPage = pi.Name Range("A5", Range("A5").End(xlDown).End(xlToRight)).Select 'range A5 so headers not included Selection.Copy ...
How to remove Hindi as input method in sheets? New sheets are ...
https://support.google.com/docs/thread/7379710/how-to-remove-hindi-as-input-method-in-sheets-new-sheets-are-automatically-named-in-hindi?hl=en Jun 3, 2019 ... I've tried changing the language from Spreadsheet ... if locale is selected to India then not only the name, the date column also start displaying ...