Using variable as row reference in VBA

[Deecrypt]

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

 

[Deecrypt]

Thank you Randy, This has given me a good point of reference.

regards
Khurram

Khurram,

I use "cells" when I want to increment through rows or columns in a
worksheet. Try something like this:

Dim CellCount as Integer
Dim OrderCount as Integer

CellCount = 6
OrderCount = 1

Do Until ........[Enter Do/Loop Criteria]

Cells(CellCount,1)=OrderCount

CellCount=CellCount + 1
OrderCount=OrderCount + 1

Loop Until .......[Enter Do/Loop Criteria]

Hope this helps...
Randy

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