huntson
06-09-2012, 11:56 AM
I have a data filter setup in excel so this means that sometimes the cells shown are not continuous - it might go from cell 5 to 7 to 100. I want to insert spaces in-between these cells. When I use
ActiveCell.Offset(-1, 0).EntireRow.Select
It obviously goes in between 5 and 7 and inserts a total of two spaces because it wants to touch 6 as well. Is there a way to have it just jump to what the data filter presents as the next row and not what really should be the next row?
I am new to this whole thing so I hopefully explained it well. Let me know if you have any questions.
ActiveCell.Offset(-1, 0).EntireRow.Select
It obviously goes in between 5 and 7 and inserts a total of two spaces because it wants to touch 6 as well. Is there a way to have it just jump to what the data filter presents as the next row and not what really should be the next row?
I am new to this whole thing so I hopefully explained it well. Let me know if you have any questions.