PDA

View Full Version : Rajan Verma's Corner



  1. Align Shapes (Charts) On ActiveWorksheet
  2. How to Get Comment by Vlookup Function :
  3. Extract Unique Values List
  4. Remove Special Characters :
  5. Unzip FilesBy VBA
  6. How to Use ParamArray (Ratio Function)
  7. Compiling Workbook Data..
  8. Get last Filled Cell address in a Range.
  9. Looping Through Each Internet Explorer
  10. Looping through Each Files and Folders
  11. Excel VBA Dictionary Object
  12. Hook Chart
  13. Bubble Chart
  14. Delete List Contain Matching from Second List
  15. Excel Chart Showing Values on Angle: Nightingale Chart
  16. Hierarchy Chart
  17. Array Class Module
  18. Heat Map
  19. Automatically Create Multiple Dynamic Named Ranges Using VBA
  20. Add VBA Reference From Another Application Excel To PowerPoint
  21. Calling UDFs by Hyperlink
  22. Exclude Contents From List :
  23. Find Mismatch Characters:
  24. Get Random List :
  25. Comment Formatting
  26. Encrypt and Decrypt Text
  27. Hierarchy Chart :
  28. Manipulate VBA Array Object Using Class Module
  29. Change Hyperlink Screentip
  30. Indexer
  31. Convert Excel Formulas That Contain Specific Function In To Value
  32. Send E-mail using Other account by outlook.
  33. Sort Data In Excel Using Formula
  34. Tree Chart
  35. Link Chart
  36. Link Chart 2
  37. Multi-Axis line graph
  38. Link Chart 3
  39. Bullseye chart - 2
  40. Bullseye Chart -3
  41. Protected: Link Chart