View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aus-JN Aus-JN is offline
external usenet poster
 
Posts: 1
Default Macro to add a blank row when a difference between rows is found

Hi All,

I would like to write a macro which selects a series of rows, sorts them by
a particular column and then adds a row whenever a difference bewteen the
rows for that particular column are found.

I can write the macrow which does the sorting but am struggling with adding
the line. I have googled this and have found many methods but unfortunately
I don't understand them enough to make them work for me - don't know which
variables I need to change etc.