View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
achidsey achidsey is offline
external usenet poster
 
Posts: 100
Default Inserting a blank row when data changes

Excel Experts:

I have a spreadsheet similar to the following

A B
1 4K3F
2 4K3F
3 4K3F
4 5B6L
5 5B6L
6 8E2B
7 8E2B

I would like my macro to go down column A, and each time the data changes
(i.e., row 4 and row 6) insert a blank row.

What code would do this?

Thanks
Alan

--
achidsey