Hello DevintheDude,
I'm assuming you're looking for a vba solution as there is no way to achieve this with
any kind of formula(s)
I'm going to need a bit of clarification before being able to provide a meaningful
example.
I want to search a column from - to 0 to + and I want to insert columns between the - and + or if their is 0's insert columns between 0 and +
You want to:
Search a column & insert one or more
row(s)? or
Search a row & insert one or more
column(s)?
While searching, say it finds a negative number and then a positive number:
(Do the insert?)
Or, say it finds a zero and then a negative number. . . (?)
Or, . . . a negative, a zero, then a negative. . . ?
Can you narrow this down a bit?