Need explaination how macro works thanks!

Closed
Chris - Jun 16, 2010 at 01:18 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 06:39 PM
Hello,

Dim lAtRow As Long
Dim lThisRow As Long
Dim Cell As Object
dim something as integer etc

Dim lAtRow As Long
Dim lThisRow As Long
Dim Cell As Object

the above statement what does it do?

please give me small example so i can learn thanks alot
wht does integer mean and what does it do?


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 16, 2010 at 06:39 PM
Dim lAtRow As Long
Dim lThisRow As Long
Dim Cell As Object
dim something as integer etc

Dim lAtRow As Long
Dim lThisRow As Long
Dim Cell As Object


Dim is used to declare variable.
Long, Integer are data type. Basically that are numbers without decimals like 1, 4, 10. Long can contain bigger number. How big, depends on version. Read on data type from help

Object is saying that this variable will contain an object which can be some thing like a range, a sheet a workbook etc


Above does nothing but says that these variables will contain down such and such type of data
0