Skip to content

@TutorialHorizon

Home
Cells Ranges Offset
Functions
Tools and Games
Automate
FSO
Operations
- Copy-Paste Opearions
- Clipboard Operations
MISC

Range

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

Function FnFillValues()

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

VBA-Excel: Working with Bookmarks- Insert text After Bookmark

January 30, 2015July 20, 2013 by Sumit Jain

For inserting the text after the Bookmark in an existing Microsoft Word Document using Microsoft Excel, you need to follow the steps below:

Add a Bookmark “IMBOOKMARK” with name “bookmark_1”

Create the object of Microsoft Word
Create Doc object using MS word object, Open the existing word document by providing the complete path
Make the MS Word visible
Get the range object for the bookmark
Insert the text after the bookmark
Save the word document
Close the word document

Categories Automate, Microsoft Word Tags BookMark, CreateObject, Documents.Open, InsertAfter, Range, Word.Application, Word.Save 1 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.

Email Address

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