The meaning of macro

J

Jentan

May I know the meaning of the macro below.


Dim Filename As Variant
Dim ImpRng As Range
Dim r As Long, c As Integer
Dim txt As String, Char As String * 1
Dim data
Dim i As Integer
Dim lastrow As Integer, lastrow1 As Integer
Dim checkdate


Dim lastrow As Double, i As Double, j As Double, k As Double
Dim m As Double, n As Double
lastrow = WorksheetFunction.Count(Columns(10))
j = 1
k = 1
m = 1
n = 1
For i = 2 To lastrow

Kindly assist. Thank you
 
J

Jim Thomlinson

That macro really does not do much of anything. It declares a bunch of
variables (the Dim statements) and then it puts values into a bunch (but not
all) of those variables. The variable lastrow is populated with the number of
cells with stuff in them from column 10 (J). There is then the beginnings of
a loop to count from 2 to the lastrow

For i = 2 To lastrow

Next i
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top