I have the code below, what is the function of the line:

" ColOut = ColOut + 1 " ??????????????


HeaderRow = Range("Header").Row
Sheets("Output").Cells.ClearContents
RowIn = HeaderRow + 1 ' first row
RowOut = 1

Do
ColOut = 1
Sheets("Output").Cells(RowOut, ColOut) = "$INPUT"
ColOut = ColOut + 1
ColIn = 2

It increments the value of the variable ColOut.

Hope this helps.

Pete

On Jul 13, 5:42 pm, M&M wrote:
I have the code below, what is the function of the line:

" ColOut = ColOut + 1 " ??????????????

HeaderRow = Range("Header").Row
Sheets("Output").Cells.ClearContents
RowIn = HeaderRow + 1 ' first row
RowOut = 1

Do
ColOut = 1
Sheets("Output").Cells(RowOut, ColOut) = "$INPUT"
ColOut = ColOut + 1
ColIn = 2

Fri, 13 Jul 2007 09:42:01 -0700 from M&M
:
I have the code below, what is the function of the line:

" ColOut = ColOut + 1 " ??????????????

It's a standard programming way of adding 1 to the ColOut variable.

I realize it looks odd, but in programming the = sign has two
meanings, "is equal to" and "is replaced by" This is an example of
the latter use, just like in
ColOut = 1

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/