Thread: Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Traima
 
Posts: n/a
Default Macro

Hi,
I need some help with a part of my macro.

I have a sheet like this
1 text1
1 text2...
1
2
2
3

I want my macro to find every change in the index (1,2,3,...) and then
insert two new rows beneath the last row with each index. I think I need some
kind of loop to locate the changes, and I can't find the right code for this.
Insertion of the rows are OK.

Thanks!