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

Sheet

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

Most Visited

  • VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook)
  • VBA-Excel: Create and Save the Word document
  • VBA-Excel: Add Table and fill data to the Word document
  • VBA-Excel: Read XML by Looping through Nodes
  • Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
  • VBA-Excel: Read Data from XML File
  • Excel-VBA : Range - Lock/Unlock Specific Cells
  • VBA-Excel: Writing Text to Word document
  • VBA-Excel: Array Functions – Join() – Converts Array to String
  • VBA-Excel: Edit And Save an Existing Word Document

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