Excel Resources
Updated 22-May-2005
Last 3 Updates
  • AudXL 1.10 Add-In
    •
  • Dynamic Autoshapes
    •
  • FaceID Explorer
    •
    Working with Ranges
  • Last Cell in Column
    •
  • Last Row/Col in Worksheet
    •
  • Speed Test Range Reads
    •
  • Number to Column Letter
    •
  • IsFormula
    •
  • Frozen Panes Top Left
    •
  • Delete Shapes in Range
    •
    VBA Stuff
  • RoundUp and RoundDown
    •
  • One line If-Then-Else
    •
  • Current User
    •
    Add-Ins
  • AudXL Add-In
    •
  • Query Editor
    •
  • FaceID Explorer
    •
  • Swift VBA
    •
    Coding at Runtime
  • Find Code in Subfolders
    •
  • Arguments from a Formula
    •
  • Finding broken References
    •
  • Add Reference
    •
  • Workbook has Macros
    •
  • Search Replace Code
    •
  • List All Procedures
    •
  • Import Module to Wkbks
    •
  • Remove Code Comments
    •
    Charts
  • Dynamic Autoshapes
    •
  • Two Type Charting
    •
  • Crop Exported Chart
    •
  • Clock Scatter Chart
    •
  • 3D Terrain Generator
    •
    Dates and Time
  • Date/Time Picker
    •
  • Hours affected by Dates
    •
  • Schedule a macro to run
    •
  • Schedule a macro by API
    •
  • Subsecond Wait
    •
    Array Processing
  • Number of Dimensions
    •
  • Array is empty?
    •
    Commandbars and Menus
  • Commandbar Buttons
    •
  • Button and Shift key
    •
  • Buttons for VBEIDE
    •
    Fun Stuff
  • Blackjack
    •
  • 3D Model
    •
    Manipulating Excel
  • In Cell Format
    •
  • Save Changes?
    •
  • Progress Bar
    •
  • Progress on Commandbar
    •
    File I/O
  • Test if directory exists
    •
  • File Path from String
    •
  • Open File Dialog
    •
  • List (Sub)Folders
    •