Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Joel Elliott   on Mar 10 In MS Office Category.

Accumalate the email address existing in a single column into a single cell with each email add


  
Question Answered By: Raquel Austin   on Mar 10

Just use the OFFSET() function. For example, if the Yes/No condition
indicator is one column  to the right of the email  address:

> For Each Str In TargetCells
> If Str.Offset(0,1).Value = "Yes" then...

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 


Tagged: