Thread: Loopy Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cody cody is offline
external usenet poster
 
Posts: 71
Default Loopy Code

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