PDA

View Full Version : Tips, Tricks & Downloads (No Questions)



  1. Correcting “Negative” Time Difference Calculation in Excel
  2. Excluding Records of one Table from the Other Table
  3. CHR() Function VBA
  4. Highlight Active Cell’s Row and Column
  5. STRCONV Function (VBA)
  6. CurDir() function VBA
  7. LTRIM() Function VBA: To Remove Spaces
  8. Did You Know? :: Super Secret Worksheets
  9. Intersection of Overlapping Ranges:Space Operator
  10. Check for Missing Attachment and Subject in Outlook
  11. Full Outer Join in MS Access
  12. Did You Know? :: Formatting Shapes in Powerpoint & Excel: Setting Defaults
  13. Forcing an Argument to be Passed by Value
  14. Custom Charts in Excel:: Comparison Stacked Column Chart
  15. Calculating Ratio Within Groups using Self Join
  16. VBA Trick of the Week :: “VBA.”
  17. Debugging Techniques in VBA
  18. Calculating Subtotals Within Groups of Data Using UNION
  19. Did You Know:: Synchronized Scrolling, Comparing Workbooks Side by Side
  20. How To Use Camera Control In Excel To Paste Picture As Link
  21. Filter In Arrays
  22. VBA Using MID Function To Replace Portion Of A String
  23. Did You Know:: 3D Reference in Excel
  24. IsDate() Function : VBA
  25. Custom Data Validation :: Using Formulas
  26. VBA Trick of the Week :: Byte Array in VBA
  27. DefType Statements in VBA
  28. How to Add Custom List And Use in Custom Sorting
  29. Did You Know :: Bullet Points & Line Breaks in Excel Cells
  30. VBA Trick of the Week :: Slicing an Array Without Loop - Application.Index
  31. Custom Charts in Excel :: Comparison RAG Chart Showing Tolerance Limits
  32. Did You Know :: Format Comment Box Using Shapes
  33. VBA Trick of the Week :: Avoid Loop for Range Calculations - Evaluate
  34. Custom Charts in Excel :: Waterfall Chart
  35. Conditional Insert Query Based on Data in Target Table
  36. Did You Know :: Excluding Hidden Cells from SUM (and other) Formulas - SUBTOTAL
  37. VBA Trick of the Week :: Conditional Compiling
  38. How To Split The Worksheet Window
  39. Str Function In VBA
  40. Format Function In VBA
  41. VBA Trick of the Week :Keeping Macros Hidden from Users
  42. Custom Charts in Excel :: Butterfly Chart
  43. VBA Trick of the Week :: Tracking the Line Number Where Error Occurs - Erl
  44. VBA Trick of the Week: Range to Recordset Without Making Connection
  45. Text Comparison
  46. How To Make A Workbook Read-Only
  47. How To Hide The Members of An Enum Statement In VBA
  48. Did You Know :: Finding All Objects & Controlling Object Visibility Using Selection P
  49. VBA Trick of the Week:: Protect Worksheet for User Actions Only
  50. How To Add Additional Metadata Hidden Information To A Workbook Or Worksheet
  51. Conditional Formatting to Create Simple Gantt Chart for Project Plans
  52. Trick of the Week :: Custom Views For an Dashboard(Excel) Using VBA
  53. Trick of the Week :: Custom Views to Control Workbook Display Options
  54. Custom Charts in Excel :: Gauge Chart (aka Dial/Speedometer Chart)
  55. The Ultimate Correlated SQL Query
  56. Opening URL @ new tab in Internet Explorer: VBA
  57. Large Operation Warning: Excel
  58. Did You Know ::: Automatic Subtotals (& More) :: Data List Outline
  59. How To Create Interactive Charts in Excel Using Chart Events
  60. Custom Charts in Excel :: Comparing Series Against Average or Benchmark
  61. Trick of the Week :: Store (and then fetch) files from SQL Server tables
  62. Network relationship chart
  63. Did You Know :: How to Hide Rows With No Data
  64. Introducing Our New Category
  65. Happy Holidays All
  66. 2014 in review - Thank you All!! 2015 will be better, we promise
  67. Dynamically Highlight Data point on Your Chart Without VBA
  68. Reverse Geocoding: Get Location Address from GPS coordinates(Latitude & Longitude)
  69. Correlated Dataset Generator