50 results
Open links in new tab
  1. excel - How to clear memory to prevent "out of memory error" in VBA ...

    Jan 18, 2013 · I am running VBA code on a large Excel spreadsheet. How do I clear the memory between procedures/calls to …

  2. How to solve Excel VBA: Compile error in hidden module

    Dec 17, 2020 · enter image description here I have a problem about excel VBA. Excel file is created for many years. It run VBA code …

  3. What Excel formula returns the sheet name? - Stack Overflow

    Feb 3, 2015 · With Excel's introduction of the textAfter function there is finally a reliable, simple way to acquire the sheet name, thus …

  4. Excel #ref error: Occurs when data is refreshed - Stack Overflow

    Oct 18, 2016 · I have made a connection in excel to another excel workbook, using the native functionality found under the data tab …

  5. Excel, append one range to the end of another in one column

    Aug 29, 2015 · I have two columns of data in Excel. I would like to add a third column which combines the first and second. How can …

  6. How to add comment inside complex excel formula

    Feb 4, 2016 · Is it possible to add a comment within the cell of an excel formula? I have an exceedingly long expression inside a cell …

  7. how to find total width of columns selected in excel?

    Feb 25, 2011 · I just want to select the columns in excel (just by clicking on each letter A,B,C and so on), then have a magic answer …

  8. Paste MS Excel data to SQL Server - Stack Overflow

    Nov 25, 2008 · Excel In Excel, highlight and copy the data you want to paste into SQL. SQL Create the table with the desired column …

  9. Convert text date/time to a real date time in excel

    Mar 28, 2016 · My data is extracted from an application and it has a text that looks like a date/time in excel. How do I actually convert …

  10. What are .NumberFormat Options In Excel VBA? - Stack Overflow

    Can you please let me know what are the .NumberFormat format options in Excel VBA? As you are fully aware Excel 2010 supports …