Question by  rano123 (109)

What should I know about VBA and range?

I'm having trouble working in Excel.


Answer by  nk409 (33)

In Excel Macro Programming, If we want to store a list of items and retreive them dynamically programmers will store information in Range. This is some thing like Stack in C Language. Eg: If you want to add two 3 items you will specify as SET data = Range("item1"),data+Range("item2"),data+Range("item3"). Ur data has item1,item2,item3.


Answer by  faithfulservant (37)

The range function returns a collection of attributes about a specific range entered as a string in quotes Range("A1:C7") or as a named range Range("MyRange"). You can assign this to a range object and carry out any number of functions to the cells the range refers to.


Answer by  gigo (1706)

You should know, that in Excel you often use 8 Byte Data values like Double, Currency or Date. These values can not be read into an integer.


Answer by  gayathrimanigandan (74)

Knowing data types range alone is sufficient to work with VBA. For example integer in 16-bit have range from 0 to 65,536 or so. Likewise know for char, float and double data types that will solve your script written in VB to work fine with Excel. Know well limits of data types throughly.

You have 50 words left!