Excel Macro edited w/VB, Add cells in columns


Posted by William Scheb on January 31, 2002 4:17 PM

I have this loop that works:

While Range("A" & i) <> ""
Range("C" & i).Select
Range("C" & i) = DealerID
Range("D" & i).Select
Range("D" & i) = "N"
i = i + 1
Wend

This does not:

While Range("A" & j) <> ""
Range("J" & j).Select
Range("K" & j).Select
Range("L" & j).Select
Range("L" & j) = Range("J" & j) + Range("K" & j)
j = j + 1
Wend

How do I subscript "J" and "K" and add them to "L"



Posted by Carl B on January 31, 2002 10:01 PM

Need more info.
What is in K and J
Your macro only Selects them, does not put anything in them.