Skip to content

Excel-Macro

@TutorialHorizon

  • Home
  • Cells Ranges Offset
    • 3D-Ranges
    • Activate
    • ActiveCell
    • Current Region
    • Select
  • Functions
    • Array Functions
    • Date Time
    • Math Functions
    • String
    • User Defined Function
  • Tools and Games
  • Automate
    • Excel WorkBook
    • Microsoft Outlook
    • Microsoft Word
    • Internet Explorer
    • XML
    • FireFox
  • FSO
  • Operations
    • Copy-Paste Opearions
    • Clipboard Operations
  • MISC
    • Macros
    • Reference Libraries
    • User Forms
    • WorkBook and WorkSheets

UsedRange.Columns.Count

VBA-Excel: Arrays – Two Dimension, Dynamic Array

January 30, 2015August 22, 2013 by Sumit Jain

For creating two dimensional dynamic array in excel, follow the steps below:

  • Declare the two dimensional Array
  • Resize the array
  • Store values in array
  • Retrieve values from array

Read more

Categories Arrays Tags Dynamic array, ReDim Preserve, Resize the array, two dimensional Array, UBound, UsedRange.Columns.Count, UsedRange.Rows.Count Leave a comment

Most Visited

  • VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook)
  • VBA-Excel: Read Data from XML File
  • VBA-Excel: Create and Save the Word document
  • Excel-VBA : Range - Lock/Unlock Specific Cells
  • VBA-Excel: Read XML by Looping through Nodes
  • Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
  • VBA-Excel: Writing Text to Word document
  • VBA-Excel: Copy/Paste data - Copy the Entire data from one sheet to another
  • VBA-Excel: Reference Libraries in Excel WorkBook.
  • VBA-Excel: Get Text from the Windows Clipboard

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Recent Posts

  • VBA-Excel: Read XML by Looping through Nodes
  • VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
  • VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
  • VBA-Excel: Create or Add Worksheets at the Run time.
  • VBA-Excel: Change Font, Color, Weight of Table Data in the Word document
  • VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
  • Send Mail With Link to a Workbook, From MS Outlook using Excel.
  • Send Mail With Multiple Different Attachments From MS Outlook using Excel.
  • Excel-VBA : Open a MS Word Document using Excel File using Explorer Window.
  • Excel-VBA : Send Unique Images Embedded to Mail Body, With Every Mail From MS Outlook using Excel.
  • Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
  • Excel-VBA : Send a Excel Workbook as Attachment in Mail From MS Outlook Using Excel
  • Excel-VBA : Open a Excel File using Another Excel File using Browse Option.
  • Excel-VBA : Send a Mail using Predefined Template From MS Outlook Using Excel
  • Excel-VBA : Send a Simple Mail From MS Outlook Using Excel
© 2022 Excel-Macro • Built with GeneratePress