About 1,677,609 results (1,835 milliseconds)
Easy way to get activesheet, activecell and/or calling cell
https://groups.google.com/g/exceldna/c/mR6jB4m1LQE difficult in ExcelDNA than VBA. For example, I have a UDF function that gets ... me, it seems there is no easy way to reference the caller. sverrirs's ...
Any way to remap "Edit the active cell" from CONTROL+U to F2?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/XN-IRcQg-gs I just bought Office 2008, but am still using Excel 2002 (under VMWare) for my workbooks that have VB :-( ... You'll just have to get used to the differences, or
How to Parse the Excel Formula using Excel DNA
https://groups.google.com/g/exceldna/c/dqq2HHcT2KE Feb 17, 2016 ... I want to Read/Parse the Active Excel Cell formula. My requirement is ... Return "<Not a reference>". End If. End Function. I tried to get ...
Setting cell value using button on the ribbon
https://groups.google.com/g/exceldna/c/eOEH9QZcCzI Aug 2, 2016 ... 1. Add a reference to the interop assembly Microsoft.Office.Interop.Excel (if you haven't got it already). · 2. Get the root Application object ...
How to refer to the Calling Cell?
https://groups.google.com/g/exceldna/c/InANJKfh5_8 May 28, 2022 ... xlfCaller) as ExcelReference;. (It might sometimes be null, e.g. if the function is called via Application.Run from VBA.) To get information ...
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range Method, Return type, Brief description. activate(), Range, Sets the specified range as the active range , with the top left cell in the range as the current ...
excel macro VBA that sums between a known cell ... - Google Answers
http://answers.google.com/answers/threadview/id/750698.html Jul 29, 2006 ... How do I make the macro insert a sum formula that sum the range of P2:ActiveCell -1. ??? In other words, sum all the cells above "Z". Here is a ...
C#: get last used column in row
https://groups.google.com/g/exceldna/c/E1fe5Qi8gGg Apr 13, 2016 ... public static ExcelReference End(this ExcelReference reference ... XlCall.Excel( XlCall.xlcSelect, current.Selection, current.Cell );.
Address of the ExcelReference is wrong
https://groups.google.com/g/exceldna/c/-F7VYMH_kVc Nov 10, 2011 ... In converting an 'internal' reference to an 'external' reference, Excel-DNA needs to determine the current sheet's SheetId. This step seems ...
Class Selection | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/selection Dec 2, 2024 ... Access the current active selection in the active sheet. A selection is the set of cells the user has highlighted in the sheet, which can be non ...
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 ... Get link. Report abuse ... In Excel you can highlight the "active cell" row and column using Conditional formatting and a small VBA code...
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 ... reference to Microsoft Excel Object Library (in com tab) ... private ...
How to find next empty cell using google script
https://groups.google.com/g/google-apps-script-community/c/ojdSGQlV6js Jan 25, 2022 ... I am trying to write code that will look at Column A, find the next empty cell, and then make it the active cell. In VBA that code is simply: ...
How to make cell formula dirty (mark for recalculation)?
https://groups.google.com/g/exceldna/c/iFBsNlxX7ZY Sep 26, 2011 ... > * For the active sheet you can call Range.Dirty. How to make this via ExcelDna? Why active worksheet only?
vb.net - Set Cell Formula in ExcelDNA UDF
https://groups.google.com/g/exceldna/c/IoDuUW7AEQ8 ... Get the correct application instance Dim xlApp As Excel.Application Dim ... cell (either current cell or other cell) by UDF? What I really want to do ...
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 ... I have been trying for days to write a script but I cannot get anything to work. ... .addItem('Based on a permanent ranges address list', ' ...
Highlight a selected row - Google Docs Editors Community
https://support.google.com/docs/thread/96419545/highlight-a-selected-row?hl=en Feb 3, 2021 ... I was wondering, is there a way to highlight an entire row when a cell is selected on that row in Google Sheets? Sounds simple, and I see excel ...
How to execute an SQL insert/update from Excel for Mac
https://groups.google.com/g/microsoft.public.mac.office.excel/c/pDIcd9jaryw Jun 22, 2004 ... Basically I can use VBA/Macro to select and put the result data into a ... 'Return the data to cell A5 on the active sheet ' SQLRetrieve Chan ...
Returning an unknown array size - and returning a new worksheet
https://groups.google.com/g/exceldna/c/zIcRRTnHj1M Oct 28, 2010 ... Going down this road, you will certainly need to get used to the Excel ... To populate a range of cells within the active sheet : object ...
Converting VBA to Google; If Statement not working - Google Docs ...
https://support.google.com/docs/thread/55561064/converting-vba-to-google-if-statement-not-working?hl=en Jun 25, 2020 ... var spreadsheet = SpreadsheetApp.getActive();. var range = e ... Does google scripts not default to the cell value similar to excel and vba?