Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting multiple ActiveCell items (possibly loop problem)
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.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Multiple items from drop down list | Excel Discussion (Misc queries) | |||
Selecting multiple items on Listbox | Excel Programming | |||
Paste Multiple listbox items starting at ActiveCell | Excel Programming | |||
Help: Activecell within Do loop problem | Excel Programming | |||
Selecting Multiple items in ListBox | Excel Programming |