jono_dude
12/19/2006 12:03:00 AM
situation: i have an excel spreadsheet that i'm trying to manipulate
data from(multiple columns). I'm trying to use activecells, but am not
quite sure how to utilise multiple active cells. here is the basic
idea of my code......
Private Sub GreenGiraffe()
Let i = 3
Do While ActiveCell.Value <> ""
Range("J" & i).Select
A = ActiveCell.Value
Select Case ActiveCell.Value
'all my case statements here
End Select
Range("F" & i).Select
B = ActiveCell.Value
Range("G" & i).Select
C = ActiveCell.Value
D = B * C * A / 1000
Range("L" & i).Formula = D
i = i + 1
Loop
End Sub
i actually think it's more of a problem to do with the loop, as when i
take it away one row of the excel sheet works perfectly.....(now that
i've tried more things, i'm pretty damn sure it's a problem with the
loop, but any suggestions are welcomed.)