Thread: Leaving a blank row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
  
Posts: 735
Default Leaving a blank row
Post your code for review.

--

Regards,
Nigel




wrote in message
...
Sheet 1, first 4 columns have values something like

1,a,b,c
1,a,b,c
1,a,b,c
2,a,b,c
3,a,b,c
3,a,b,c

On report -sheet 2 - I'like to have a blank row between each
different value on column A. Like below

3 rows for 1
1 blank row
1 row for 2
1 blank row
2 rows for 3

I've had no difficulty coding my report so far. But leaving these
blank rows I couldn't manage.
Any helping code snippets will be really appreciated. Thank you.

Reply With QuoteReply With Quote