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

Current Region

VBA-Excel: CurrentRegion

January 30, 2015May 13, 2013 by Sumit Jain

CurrentRegion analyses the filled cells and the blank cells surrounded by the rangeyou provide. Its returns a Range object as a region in Mxn shape.

Syntax:

RangeObject. CurrentRegion

Example:

Function FnCurrentRegion()

   Dim mainWorkBook As Workbook

   Set mainWorkBook = ActiveWorkbook

Read moreVBA-Excel: CurrentRegion

Categories Activate, Cells Ranges Offset, Current Region, Excel WorkBook 1 Comment

VBA Excel – Looping Through a Range of Cells

January 30, 2015May 4, 2013 by Sumit Jain

Referring Excel cells using For…Next -Loop

For i = 1 to 10

Range(“A” & i).Value = 1

Next

Enter ‘1’ in Cells from A1 to A10.

Referring Columns of excels using For-Loop

For i = 1 To 26

Range(Chr(65 + i) & "1").Value = 2

Read moreVBA Excel – Looping Through a Range of Cells

Categories Activate, ActiveCell, Cells Ranges Offset, Current Region, Excel WorkBook, Excel-Macro-VBA, Select Leave a comment

Most Visited

  • VBA-Excel: Read Data from XML File
  • VBA-Excel: Create and Save the Word document
  • Excel-VBA : Range - Lock/Unlock Specific Cells
  • VBA-Excel: Reference Libraries in Excel WorkBook.
  • VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook)
  • Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel.
  • Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
  • VBA-Excel: Read XML by Looping through Nodes
  • VBA-Excel: Arrays – Two Dimension, Dynamic Array
  • VBA-Excel: Open 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.

Join 655 other subscribers

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
© 2021 Excel-Macro • Powered by GeneratePress