Need explaination how macro works thanks! [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!