Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need help figuring out the syntax for using the counter
from a 'For' loop in the cell references. I marked the lines I have wrong w/ 'X'. Both errors involve passing the value of 'counter' into a 'Range' statement to specify the row number in a Cell designation. Dim counter As Integer Dim temp As String For counter = 1 To 10 temp = Worksheets("Sheet1").Cells(counter, 1).Value Select Case temp Case apple X Range("A'counter':H'counter'").Select Selection.Copy Sheets("Sheet2").Select X Range("A'counter+43'").Select ActiveSheet.Paste Case .... End Select Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Help: Visual Basic Syntax | Excel Programming |