Hey all first post,

I am trying to help a co-worker who is trying to write VB code tha
will take a range that includes blank rows and writes it withou
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 th
data will end up in access in the future and do not want to have th
erroneous data included

Thank you for your guidance

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

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/

I guess this might help, the sheet displays like this:

123
456
789

123
456
789

I want to keep the blank row to seprate the data

It has been removing the blank row and I want to KEEP i

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