Erlandsen Data Consulting
Erlandsen Data Consulting
VBA Tips
(current)
(current)
About EDC
Om EDC
Cookies
Search this site
Recent
Addins
ADO
Application
Arrays
Charts
Commandbars
Count
Dates
Dialogs
Events
File access
Files & Folders
Functions
Games
Help
Import & Export
Lookup
Off topic
Other
Outlook
PivotTables
Power Query
Printing
Problem solving
Read me
Searching
Sorting
Sound
Strings
Sum
Time
VBA programming
VBE
Workbooks
Worksheets
Worksheets
Updated
Move and resize a worksheet shape object to cover a given worksheet range
2016-10-07
Set row height and column width in millimeters
2016-09-08
Expand all collapsed Outlines and restore them later
2013-08-07
Remove duplicate items from a worksheet range
2012-02-08
Retrieve a worksheet based on the worksheet contents
2011-07-21
Retrieve a worksheet based on the worksheet name
2011-07-21
Quickly delete rows in a worksheet
2010-10-16
Protect all cells containing formulas in a worksheet
2009-12-17
Find lost or forgotten passwords
2008-07-04
Add subtotals before page breaks
2006-05-18
Return how many characters that will fit within the column width
2006-01-27
Compare two worksheets
2005-06-09
Returning the page range addresses from a worksheet
2004-10-08
Apply a default header / footer using Custom Views
2004-06-07
Insert headers and footers
2004-06-03
Row and column background color
2002-07-17
Compare list items
2002-04-02
Cells with "memory"
2002-01-26
Worksheet map
2000-08-08
Row shading
2000-08-08
Apply a custom format to the active cell
2000-08-08
Copy visible cells from a filtered list
2000-08-08
Conditional formatting of cells
2000-08-08
Insert pictures
2000-04-15
Determine if a cell is within a range
1999-12-20
Compare two worksheet ranges
1999-12-20
Copy column widths and row heights
1999-12-20
Delete rows and columns
1999-12-20