need explaination how macro works thanks! Closed

Question

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?


Configuration: Windows XP / Internet Explorer 6.0

rizvisa1 · Answer

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

Need explaination how macro works thanks!

1 response

Similar discussions

Subscribe To Our Newsletter!