CELLS() and RANGE() – Are they same? Are they Excel VBA Object?

Dear Friends, Many of you who are interested in excel Macro or if you have ever tried to read and understand a VBA code, you would have seen two ways of referring a cell in Excel Macro: Using Range() To refer value of Cell D4, you can use Range("B4").Value. To know more about RANGE() you can read my previous article [...]

Excel Macro Beginners – What is Range Object in Excel VBA

Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I can say that RANGE is a collections of cells which are in a sequence. This collection can have one or more than one cell. As I have defined, Range is a collection of [...]

Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)

Dear Friends,   Let's take a brief re-cap of what all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learnt about all the Controls available in Excel Macros and also how to use them? You have also learnt How to [...]

By |Categories: Excel Macro|Tags: , , , |0 Comments