hip2b2
Board Regular
- Joined
- May 5, 2003
- Messages
- 135
- Office Version
- 2019
- Platform
- Windows
I have a small report but the format is somewhat irregular.
The report is several lines of header text
Followed by 1 or more empty rows
Followed by 1 or more consecutive rows of data
Followed by 1 or more empty rows
etc.
I have been looking for VBA code (with no luck) to reduce the 1 or more empty rows to only 1 empty row separating the different data sets..
As always any help is appreciated.
hip
The report is several lines of header text
Followed by 1 or more empty rows
Followed by 1 or more consecutive rows of data
Followed by 1 or more empty rows
etc.
I have been looking for VBA code (with no luck) to reduce the 1 or more empty rows to only 1 empty row separating the different data sets..
As always any help is appreciated.
hip