Hi everyone and thanks to those who can help...
I'm looking to create a macro that inserts an empty row if the difference between two consecutive cells in the same column is >1.
e.g., if column A =
0
0
0
0
2
2
it would become
0
0
0
0
0
2
2
and so on throughout the remainder of the column.
I hope someone can help.
Thanks!
Hi, ulyhappy,
this code starts at the bottom and works it´s way up:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Genius, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks