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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable as row reference in VBA
Thank you Randy, This has given me a good point of reference.
regards Khurram RST wrote: 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 "Deecrypt" wrote: 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 |
Reply |
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 |