Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
VBA Array Excel Excel VBA Macro

VBA – Find number of Dimensions in an Array

July 18, 2022
Kumarapush

How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.

VBA Array Tricks
  • VBA – Create Array from Excel Range – 1 Dimension
  • Excel Vba Sort Array – Quick Trick using built in function
  • VBA – Add Items to Array – Dynamic Resize without erasing data
  • Excel VBA – Convert Range To Array – 2 Dimentional
  • VBA Array Initialize Values – Split string to array
Excel Tricks
  • VBA Msgbox with Yes No Cancel Options
  • SUM and Average of Top N Values in Excel
  • Excel VBA – Copy Workbook – Active or External
  • Extract URL Links from Sitemap.xml file using Excel
  • [VBA] Read Values in Data Validation Drop Down List
Excel VBA Macro Tricks
  • Clear Excel VBA Immediate Window – Macro Code
  • Excel VBA Text To Speech – Voice Application Activation
  • Hide Desktop Icons of Active Windows Applications
  • Excel VBA Remove Duplicates Values
  • VBA Code – Create Index of Worksheets – with Links to each Sheet
  • Save Web Page to PDF from Chrome, Edge, Firefox
    How to Save Web Page as PDF File – No Plugins Required
    Use this easy trick to save the Web page to PDF file. It is a straight forward method that enables to save whole website page into single PDF file.
  • Replace #NA in Excel with Zero or Empty blank space with Formula
    How to Replace #N/A in Excel with 0 or blank – using Formula?
    How to replace #N/A in Excel with 0 or blank values using formula. Usually a formula like Vlookup returns such errors & this Excel function can handle this.
  • Net Run Rate - Formula to Calculate - IPL Cricket T20 OneDay Points Table
    Net Run Rate Calculation in IPL, T20 & One day Cricket – Formula
    Here is how the Net Run Rate is calcualted in Cricket matches. This run rate calculation formula is applcable to IPL, T20 & Oneday tournaments.
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved