Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable as row reference in VBA
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable reference | Excel Programming | |||
How to use variable in reference | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Variable reference | Excel Programming | |||
Using a variable as a row reference? | Excel Programming |