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

two dimensional Array

VBA-Excel: Fill Excel Range Values in a 2D Array

January 30, 2015October 4, 2013 by Sumit Jain

You can fill a range values from an excel work book into a two dimensional array. All you have to do is assign range values to a variable and then that variable will become array

Two Dimensional Dynamic array -1
Two Dimensional Dynamic array -1

Function FnFillValues()

Read more

Categories Arrays, Excel WorkBook, Excel-Macro-VBA Tags Dynamic array, Range, Sheet, two dimensional Array 1 Comment

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

VBA-Excel: Arrays – Two Dimensional, Static Array

January 30, 2015August 21, 2013 by Sumit Jain

Two dimensional array works like Mxn matrix.

Two Dimensional Array -1
Two Dimensional Array -1

For creating two dimensional static array, follow the below steps

  • Declare an two dimensional Array
  • Store values in array
  • Retrieve values from array.

Read more

Categories Arrays Tags Arrays, Dynamic array, Retrieve values from array, static array, two dimensional Array 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
  • VBA-Excel: Reference Libraries in Excel WorkBook.
  • VBA-Excel: Open an Existing Word Document
  • VBA-Excel: Add Table and fill data to the Word document
  • Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
  • VBA-Excel: Copy/Paste data - Copy the Entire data from one sheet to another

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