View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Inserting 2 rows above a certain cell

In this case, one between last 3 and first 7? Or, 3-7 and 1-3?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KDJ" wrote in message
...
I have a column with numbers that are sorted in ascending order e.g

1
1
1
3
3
3
7
7
7

The highest number possible is 8. I would like to insert a line above the
spot where the number changes. How can I do this?
--
Thanks very much. KDJ