View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Coker Alex Coker is offline
external usenet poster
 
Posts: 2
Default Looping thru a range - storing IF not blank?

Can anyone help with this task? I have never used VBA, but I am a
programmer.

I have a worksheet of survey results. It has five questions and allows for
five answers and comments. I want to consequtively report the comments to
the employee in a report. In other words, I have a range of comment cells,
some of which have content (most do not). I want to loop through the range
and when the comment cell has content, store it in another cell.

If you need more information, please ask.

Thanks,
Alex