Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have four columns I am working with B344:E362. Column B I am trying to
populate based on a list of options from D. Column E is a list of TRUE or FALSEs based on whether the value should be added to column B. I am trying a loop at follows and I don't think I am on the right track. Dim Check, AddValue Check = Sheets(Defaults).Range(D344).Value AddValue = Sheets(Defaults).Range(B344) Do If Sheets(Defaults).Range(E344) = True Then AddValue = Check Else End If Check = Check.Offset(1,0) Loop Until Check = Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Loopy? | Excel Worksheet Functions | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |