PDA

View Full Version : Excel and VBA Tips and Tricks



  1. Remove Zero / Zeroes From Alphanumeric Text
  2. Converting a Column Number to a Column Letter
  3. Deleting blank rows
  4. Finding Last Used Row or Column In Excel Sheet
  5. Find Last Used Row In Column
  6. Average Of The X Largest Numbers
  7. Add Control to List On Right-Click
  8. Hide Ribbon and Formula Bar
  9. COUNTIF on Non-contiguous Range
  10. Changing Hyperlink To Another Sheet By Changing Value Of Cell
  11. Count Files In A Folder VBA
  12. Find The Last Entry Row In A Column That Contains Only Numbers
  13. Execute SQL From Excel (VBA)
  14. Save Chart As A Picture VBA
  15. Number of Days In A Month
  16. FreezePane In A Userform SpreadSheet Control 11.0
  17. Convert Text In YYYYMMDD Format To Date Format
  18. Excel Macro Functions (GET.CELL)
  19. Excel Macro Functions (GET.DOCUMENT)
  20. VLOOKUP with Multiple Results
  21. Find Parent Folder From Given Folder / File Path
  22. Search Directories to List Files VBA
  23. Open Folder Using VBA
  24. Last Filled Cell Having Text
  25. Formula To Identify A Cell Has Duplicate Words
  26. Lookup Multi-Column For Unique String Combination For Numeric Value Output
  27. Count Alpha In AlphaNumeric Text
  28. Replace Currency Format From One to Another at One go !! (VBA)
  29. Pass Values Between Multiple Userforms
  30. Add Shape With Hyperlink To Another Sheet
  31. Change Case of Text in Excel
  32. Delete Names In A Specific Worksheet
  33. List all Worksheet Names Using Formula
  34. Unique Count on a Filtered Range
  35. Class Objects Created Using the CreateObject Method That Employs Late Binding
  36. Rename Filename Through VBA
  37. VBA Code to Clear the Immediate Window.
  38. Lock Cells After Data Entered
  39. VBA to Return the UNC(Universal Naming Convention) Path of a Mapped Network Drive
  40. Learn Excel and VBA - Useful Links
  41. FindAll Function In VBA
  42. Trim all Cells in a Worksheet - VBA
  43. List Unique/Common Values From Two Ranges
  44. Count words having more than one character in a cell
  45. Unique Large Values From Duplicate List
  46. Minimize/Maximize Ribbon using VBA
  47. On Error Statement (Visual Basic)
  48. Export data from Excel to Access Table (ADO) using VBA
  49. Highlight Current Row in Excel (VBA)
  50. Extract Number From Alphanumeric Text
  51. Sort Worksheet by Color VBA
  52. Sort data sheet by right_click of mouse
  53. Saving Embedded Picture From Excel Workbook Sheet To Folder Hard Drive
  54. Upload Excel Data to SQL Table
  55. Checking Table Exist in Access Database or Not
  56. Get Chart's Source Data VBA
  57. Highlighting All the Cells of Active sheet which contains a particular String:
  58. Minimum Value Excluding Zero In Excel Range
  59. Create Random Number Generator VBA
  60. IIF Function in VBA
  61. Nth Largest Unique Value in an Array (UDF)
  62. Delete Name Ranges by Scope VBA
  63. Split Range into Multiple Columns VBA
  64. Week Of The Month
  65. Spell a Date out in Words
  66. Find Merged Cells VBA
  67. Excel Dynamic Waterfall Chart
  68. Range Difference VBA
  69. Excel to Excel Data transfer without opening any of the files(source or target)
  70. VBA Function to Search in Array
  71. Find Quarter Month From Date In Excel
  72. Replace Pivot Table Source Range with New Address VBA
  73. Default Cell Format Changed to Date
  74. Validating PAN (Indian Format)
  75. Number validation in Text Boxes VBA
  76. Date & Time Formats in Different Languages
  77. Delete worksheets without loop
  78. Remove Unused Custom Styles VBA
  79. Copy/Paste Excel Range/Chart into Powerpoint VBA
  80. Consolidate multiple workbooks from a folder into one master file VBA
  81. Random Unique Number Generator Excel VBA
  82. VLookup Any Matching Word From A Sentence
  83. List File Names Using Formula
  84. Replace Incorrect Date In Cell To Another Valid Date
  85. Freeze Time Using Excel Formula To Freeze Date
  86. Loop Through And Delete Multiple File Types In A Folder
  87. Retain Conditional Format Color When Copying A Range To Another Sheet Or Workbook
  88. Remove Special Characters From Text Or Remove Numbers From Text
  89. Extract Selected Data from Excel - Advanced Filter
  90. Change Pivot Table Data Source Using A Drop Down List
  91. Filter Pivot Table Based On Selected Value And Show All Results Though VBA
  92. Reverse a string by using array method
  93. Office Version Independent Non-Activex Date Time Picker Using Form Controls
  94. Dynamic Chart That Expands As More Data Is Added
  95. Finding Selected Criteria in AutoFilter
  96. Status Bar Progress Meter
  97. Upgrade to LookUpConcat UDF: Search Multiple Criteria and concatenate.
  98. Backup all modules, class modules and userforms to a selectable folder
  99. Create Or Update A Hyperlink Index Of Visible Sheets
  100. Function Code for getting Column Letter from Column Number
  101. Date Format Issue When Regional Language Setting Changes And You've Used TEXT Formula
  102. Summary Of Maximum Rows Used Across Each Sheet In A Workbook
  103. A Blinking Christmas Tree
  104. Remove a particular legend from a Chart using VBA
  105. BBCode Table
  106. Unpivot Columns in Excel
  107. Showing progress bar in a status bar :)
  108. Excel VBA comma point thousand decimal separator number problem.
  109. How to Use the AutoSum Function in Microsoft Excel
  110. WithEvents of Excel.Application Events
  111. Class Stuff: VBA Custom Classes & Objects, Class Modules
  112. ExtendingInsensibility into Code modules. Copy table contents to VBIDE VB Editor code modules. ..
  113. UDF that can change values in cells other than the cell in which the UDF is used
  114. "What’s in a String"- VBA break down Loop through character contents of a string
  115. VBA Range.Sort with arrays. Alternative for simple use.
  116. Recursion Procedures in Excel VBA. Recursion technique in coding
  117. Position that light grey Boarder line anywhere in the VB Editor
  118. Item way of thinking as alternative to conventional row column looping.