If I understand that you want the visible cells, look in vba HELP index for
specialcells and then xlvisible.

--
Don Guillett
SalesAid Software

"vb noobie " wrote in message
...
Hey all first post,

I am trying to help a co-worker who is trying to write VB code that
will take a range that includes blank rows and writes it without
deleting the blank rows.

Is this possible to do, or a simple limitation of the program.

Basically for ease of reading we just want to maintain row separation.

We have thought about simply entering data and hiding this however the
data will end up in access in the future and do not want to have the
erroneous data included

Thank you for your guidance!


---
Message posted from http://www.ExcelForum.com/