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
|