View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Quin Quin is offline
external usenet poster
 
Posts: 37
Default VBA code to "skip" empty rows

Mike H,

Thanks for fixing my code. I can see how the €śRange€ť statement can be used
to accomplish my task. The result is exactly what I needed and wanted.


Jessen,

I found a lot of interesting information in your reply, but since I am
learning, I also have several questions. I hope you have a minute to answer.


1. I dont understand why it is frowned upon to use goto statements. It
seems like such an easy and straight forward thing to do.
2. I cant get my mind around using a < symbol. I tried to Google it with
no success.
3. I Googled €śTrim€ť to find it removes leading and trailing spaces but not
sure why that helps in this case.
4. Im not sure why the text frame section is commented. Is that just to
use default settings when the text boxes are created?

My last observation is €śI must be Dyslexic€ť Very poor of me to not notice my
confusion on the use of the €śCells€ť statement. I appreciate your comment to
direct my attention to it.
Thank you Mike and Jessen

Quin