Thread: IF using VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
confused confused is offline
external usenet poster
 
Posts: 193
Default IF using VBA

I was wondering if you could help me with a little vba .. I have some code
that populates a summary page .. I am needed to change this part where it's
populating the below code under quantity
.Range("E10") = wsSource.Range("B5")

Somehow I need it to populate .Range("E10") with a number based on another
field

so if wsSource.Range("B6")= "Quarterly in Arrears", .Range("B8"), Else
..Range("B9")

How do I do that? Thanks!