32 Bit And 64 Bit Api Declarations For Vba Developers

3 minute read A whole heap of declarations for 32 and 64 bit operating systems. ‘// for developers ‘// 34 bit declarations Private Declare Function FindWindow Lib “User32.dll” Alias “FindWindowA” (ByVal lpszClass As String, ByVal lpszWindow As String) As Long Private Declare Function MoveWindow Lib “User32.dll” (ByVal HWnd As Long, ByVal X As Long, ByVal … Read more

Delete Rows In A Column That Are Blank

1 minute read Here I outline lots of ways that you can delete blanks rows in any chosen column. ‘## If you have a Column with data and blank Cells, ‘ you can delete the blank Rows using this method ‘ starting at Cell “A2” or for Column “A” ‘ (requires error trap for xlCellTypeBlanks … Read more

Prevent Sheet Being Deleted

less than 1 minute read Title: “Worksheet event to prevent the sheet being deleted” layout: single classes: wide categories: vba tags: validation developer function date: 2019-02-06 sidebar: title: “Popular Links” nav: sidebar-sample This prevents any worksheet from being deleted by accident using the right click –> delete method. Pesky users! ‘========================================================================================================== ‘ ## Prevent worksheet … Read more

Word Count From Cells

less than 1 minute read There’s no built in way to count the number of words in Excel, but using the following formulas will get it done. Download the example workbook here: Word Count.xlsx Count the number of words in a cell ‘ A2 as the following sentence (without quotation marks) to get the word … Read more

Put A Row Number On A Table

less than 1 minute read Here’s a simple way to get the row number of the table items. It’s a simple formula referencing the current cell’s row minus the row number of the table header row. In this example I’ve changed the table name to MyTable =ROW()-ROW(MyTable[[#Headers],[Row ‘#]]) Tags: tables Categories: formulas Updated: September 16, … Read more

Special Characters And Symbols

1 minute read You can always use the Insert –> Symbols method to enter characters onto your spreadsheet but you can also add them via a formula. Formula Result: Exchange Rates Chart (£), Euro (€) and Dollar ($) =”Exchange Rates Chart (” & CHAR(163) & “), Euro (” & CHAR(128) & “) and Dollar (” … Read more

Create A Table Of Contents

6 minute read This one is pretty sweet. It creates a nicely formatted TOC sheet and a back button on each sheet that links to the TOC. If you happen to add a sheet, simply click the delete back button then click refresh buttons to simply Refresh! ‘ ====================================================================================================== ‘ ## Master macro which calls … Read more