Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cesar Gonzalez   on Jan 31 In MS Office Category.

  
Question Answered By: Murad Bashara   on Jan 31

I think we each answered quite different questions, actually. I answered
the literal question of how to copy  from a two-cell range  to another,
conditionally, but it seemed an add thing to want to do. The way you
interpreted the situation, though, makes more sense to me as something
worth coding!

You'd still need a 'for each' loop to evaluate each cell  in the range
individually if you wanted to do that.

I use range names all over the place, both in VBA and in formulae,
mostly because it makes a sheet easier to troubleshoot weeks after
you've moved away from it.

The next step is dynamic range names which are the best thing since
loincloths.

Share: 

 

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

 


Tagged: