View Single Post
  #1   Report Post  
Scott Steele
 
Posts: n/a
Default How can I dynamically eliminate blank cells in a given range in E.

I have several groups of related cells that I have pulled together into a
single range. Now I want to get rid of the blank cells in that range so it
is a single continuous list. There are four groups of five cells each. I
have seen this done in another worksheet, but the formulas for that sheet are
so complicated I don't think I can figure it out.