Saturday, December 13, 2008

Clear a Worksheet

Want to clear your current worksheet?  Use this:

'Select the whole spreadsheet
Cells.Select
'Delete Everything
Selection.ClearContents
'Make Cell A1 the Currently Selected Cell
Range("A1").Select

at No comments:

Quick Tip for Viewing Excel Macro's

Want to quickly view your Excel Macro's?  Click ALT-F11.  This will pull up the Microsoft Visual Basic Editor with all of your current workbooks' macros.  Quick, simple access to your macros!

at No comments:
Subscribe to: Posts (Atom)

Time Math in Excel

You can use the TIME() function to add or subtract hours, minutes or seconds in Excel.  The TIME function takes 3 parameters; HOURS, MINUTES...

  • Delete the Last Line of Data
    I frequently import a specific data-set of text data into Excel.  After I import the data, I need to delete the last line of data. Following...
  • Get the Logged in Users Name
    To get the name of the currently logged in user, you need to first, create a function to call a Windows API function to get the user name.  ...