Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
teach me how to do range address syntax
I need some one to teach me a finer point of specifying range
addresses. I can do the simple stuff but I want to have a range address that includes a constant and a variable like might be the case in a loop. I've tried several approaches and I usually get an error message ("compile error: expected: list separator or )") when I enter the line. Here's a simple example of what I want to do: For i = 1 to lastrow Range("A" & i:"D" & i) = something Next i For each row in the loop set cells A, B, C and D to the same value. Thanks for pushing me further down the learning curve! John Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
teach me how to do range address syntax
hi
you have a small syntax problem. try this... Range("A" & i & ":D" & i).Select regards FSt1 "John Keith" wrote: I need some one to teach me a finer point of specifying range addresses. I can do the simple stuff but I want to have a range address that includes a constant and a variable like might be the case in a loop. I've tried several approaches and I usually get an error message ("compile error: expected: list separator or )") when I enter the line. Here's a simple example of what I want to do: For i = 1 to lastrow Range("A" & i:"D" & i) = something Next i For each row in the loop set cells A, B, C and D to the same value. Thanks for pushing me further down the learning curve! John Keith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
teach me how to do range address syntax
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation? | Excel Discussion (Misc queries) | |||
How to use the 'if' - function? Pls teach me... | Excel Worksheet Functions | |||
Target.Address syntax | Excel Worksheet Functions | |||
Is it possible to teach ones self VBA? | Excel Programming |