About 1,377,413 results (3,337 milliseconds)
Highlite row based on active cell - Google Docs Editors Community
https://support.google.com/docs/thread/78273237/highlite-row-based-on-active-cell?hl=en Oct 21, 2020 ... Highlite row based on active cell · 1. Code is highlighting both row and column that is fine. · 2. But i cannot set the format in any cell because ...
excel macro VBA that sums between a known cell ... - Google Answers
http://answers.google.com/answers/threadview/id/750698.html Jul 29, 2006 ... Select Selection.Find(What:="Z", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, ...
Easy way to get activesheet, activecell and/or calling cell
https://groups.google.com/g/exceldna/c/mR6jB4m1LQE It seems the R1C1 way of referencing a cell (or getting the active/calling cell) is more difficult in ExcelDNA than VBA.
Class Selection | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/selection Dec 2, 2024 ... The current cell is highlighted with a darker border in the Google Sheets UI. const activeSheet = SpreadsheetApp ...
Setting cell value using button on the ribbon
https://groups.google.com/g/exceldna/c/eOEH9QZcCzI Aug 2, 2016 ... Proceed as in VBA: xlApp ... Is it possible instead of setting it to the active cell, it can set it to a specified cell in the code?
Highlight a selected row - Google Docs Editors Community
https://support.google.com/docs/thread/96419545/highlight-a-selected-row?hl=en Feb 3, 2021 ... ... row,,,. If its vba code that's fine,,,. I just want to select any cell in a sheet, and when I do,, the entire row the selected cell is on ...
Highlighted Row in Google Sheets Not Dark Enough - Google Docs ...
https://support.google.com/docs/thread/11766885/highlighted-row-in-google-sheets-not-dark-enough?hl=en Aug 11, 2019 ... Ps,. In Excel you can highlight the "active cell" row and column using Conditional formatting and a small VBA code...
How to make cell formula dirty (mark for recalculation)?
https://groups.google.com/g/exceldna/c/iFBsNlxX7ZY Sep 26, 2011 ... implements live streaming web quotes. Some other ideas: * For the active sheet you can call Range.Dirty. * Set the formula to the current cell ...
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range Sets the specified range as the active range , with the top left cell in the range as the current cell . const sheet = SpreadsheetApp ...
vb.net - Set Cell Formula in ExcelDNA UDF
https://groups.google.com/g/exceldna/c/IoDuUW7AEQ8 This limitation is in place whether you are using VBA or C++ or Excel-DNA to implement the UDF. ... cell (either current cell or other cell) by UDF? What I really ...
cell auto format when inserting date
https://groups.google.com/g/exceldna/c/W_sgeDTQZ_Y How to insert data with exceldna with auto-format, like in VBA example? Thx ... // Select a cell on the active sheet. XlCall.Excel(XlCall.xlcFormulaGoto ...
Easy way to insert current date+time into a Sheets cell * on Android ...
https://support.google.com/docs/thread/178172581/easy-way-to-insert-current-date-time-into-a-sheets-cell-on-android-phone?hl=en Sep 6, 2022 ... I'd like an easy way to put a current timestamp into a cell for each row when I make a reading, using Sheets on my Android phone.
Print Specific Cells on Current sheet via Macro or Script - Google ...
https://support.google.com/docs/thread/150423681/print-specific-cells-on-current-sheet-via-macro-or-script?hl=en Feb 11, 2022 ... I then select the "Selected Cells" drop down and hit next. Is there a way of automating that whole process ? It is very important this refers to ...
How to find next empty cell using google script
https://groups.google.com/g/google-apps-script-community/c/ojdSGQlV6js Jan 25, 2022 ... ... row number for the first blank cell in ... cell, and then make it the active cell. In VBA that code is simply: Range("A:A").Find("").Select.
Script to copy and paste selected range to set range - Google Docs ...
https://support.google.com/docs/thread/260055529/script-to-copy-and-paste-selected-range-to-set-range?hl=en Feb 22, 2024 ... 1. Select a range on sheet 1 (this is a changing variable) 2. Paste that into a set range on sheet 2 from H14 (this is a constant)
Add background colour if strike through, works but now slowed up ...
https://support.google.com/docs/thread/113759576/add-background-colour-if-strike-through-works-but-now-slowed-up-execution?hl=en Jun 16, 2021 ... Logger.log('Active Range: ' + selection.getActiveRange().getA1Notation()); ... I am pretty good at VBA, done some large applications but ...
Positioned in a particular tab when open a google sheet - Google ...
https://support.google.com/docs/thread/33145022/positioned-in-a-particular-tab-when-open-a-google-sheet?hl=en Mar 11, 2020 ... A1 selected. This is the default behavior of Google Sheets". I did not know this feature. As my file contains many tabs I ...
Open Sheet to the cell with the current Date - Google Docs Editors ...
https://support.google.com/docs/thread/144148425/open-sheet-to-the-cell-with-the-current-date?hl=en Jan 5, 2022 ... I have created sheet "Menu". In there you will see a list of links pointing to various Monday dates, making it easier to travel back and forth.
CLEAN function - macro??
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/jsHw9KXMKuU I.e., whatever is selected in the active worksheet can be interrogated via the ... learn the count of selected cells in the worksheet, or create a one cell
Google Sheets macro to click on a cell and do a find/replace on the ...
https://support.google.com/docs/thread/42542405/google-sheets-macro-to-click-on-a-cell-and-do-a-find-replace-on-the-cell-above-it-or-send-keystrokes?hl=en Apr 26, 2020 ... Finally, one possible complicating factor is that I don't definitely know the name of the tab that will be active. Even if a user doesn't change ...