Need explaination how macro works thanks!
Closed
Chris
-
Jun 16, 2010 at 01:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 06:39 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 06:39 PM
Related:
- Need explaination how macro works thanks!
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 16, 2010 at 06:39 PM
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
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
