Some basic to intermediate VBA tips from www.automateexcel.com
- Selva V Pasupathy, HSBC Global Resourcing, Hyderabad, India
- Test For Internet Connection
- Export Range to Delimited Text File
- How to select cells/ranges
- Array Examples
- Remove Characters from Left or Right Side of Variable Length String
- Using Ranges
- WinHttpRequest with Login and Password – Misc Bloglines
- Send Email
- Language References
- Yes or No Message Box
- Zoom – Fit Selection
- Delete All Named Ranges
- Delete Hyperlinks
- Test if Workbook is Open, by Workbook Name
- Loop Through a String
- ActiveWindow.WindowState
- Transparent Forms
- Turn On/Off Scroll Bars
- Freeze Panes
- Programming The VBE
- Remove Blank Rows
- Environ Function
- Unhide All Worksheets
- Refresh XML Source – Updated
- Test if Selection is Range
- Size an Object to a Range Size
- Refresh XML Source
- Best Practices
- Delete All Autoshapes
- Code Indenter
- Speak to Me
- Consume Soap Web Services
- Determine a Variable’s Underlying Type
- Force a Workbook to Save
- Loop Through a String
- Column Width and Row Height
- Zoom…Zoom
- Import File Names to Clickable Links
- Page Break Preview
- Add Delay to Your Code
- Turn Off – Turn On Calculation
- “dirty area”
- Hide a Macro
- Exit Without Saving
- Timer
- Row Height – Column Width
- Turn On Formula Bar – Turn Off Formula Bar
- Add Spaces to a String – Space()
- Join Multiple Ranges
- Display Fullscreen
- Check Spelling
- Change a Cells Background Color
- Find method
- Select All Cells
- Benchmarking Code
- Run a Macro When a Cell Changes
- Format Painter
- Autofit All Columns Used
- Count the Number of Used Rows
- Count the Number of Used Columns
- Macro to Create a Hyperlink Menu of Worksheets
- Macro to List all Sheets in a Workbook
- Scroll Vertically and Scroll Horizontally
- Use Worksheet Functions in a Macro
- Programmatically Draw Boxes with Code
- Color Reference For Colorindex
- Cut, Copy, Paste from a Macro
- Write Data After Last Row Used in a Column
- Select Non Contiguous Columns
- Remove Formatting For Each Cell In Range
- Find Text in a String (instr)
- How To Activate a Sheet
- Turn Off Autofilter From Code
- Turn On Autofilter From Code
- Code or Program a Data Validation List
- Loop Through a Range
- Set the Default Sheet When a WorkBook Opens
- Use a Variable in Multiple Modules or Subs
- Determine Start and End Column of a Merged Cell
- Run a Macro Line by Line
- Line Break or Line Feed in a Message Box
- Add or Remove Cell Comments from a Macro
- Macro to Update all Worksheets in Workbook
- Macro to Autofill
- Autofit Columns
- Select a Worksheet by Tab Name
- Convert Excel to CSV (Comma Delimited Text File)
- Prevent warning messages from a macro
- Input from a User in a Macro (InputBox)
- Run a Macro from a Macro
- Turn off Screen Updating
- Count the Columns in a Selection
- Count the sheets in a Workbook
- Count the rows in a Selection
- Status Bar Updating
- Force Proper, Upper, or Lower case automatically
- Run a macro when Excel closes
- Run a macro when Excel starts
- Get the active cell’s Column
- Get the active cell’s Row
- Add a simple timer
- UnHide a worksheet
- Hide a worksheet
- Find the last row used
- Build a custom import
- Show or load a form when Excel starts
Contents of this Site « Selva’s Blog said
[...] Tips on VBA [...]