KEEP blank rows when coding ranges

[vb noobie]

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

 

[Don Guillett]

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

 

[vb noobie]

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