Hi,
In my macro, I'm trying to reference an integer as a row reference.
The idea is that as the macro goes through the worksheet, the integer
will increment where required. Currently the cell is in column A. Any
help would be greatly appreciated.


Dim CellCount As Integer
Dim OrderCount As Integer

CellCount = 6
OrderCount = 1

Range("A&CellCount&").Select
ActiveCell.FormulaR1C1 = OrderCount

OrderCount++


Thank you kindly
Khurram