Hello. I have a column of data with values in A5, A15, A25, A35, etc. The cells in between these are empty. I need a macro that will find the next cell in the column, select it and the empty cells below so I can fill down without filling over the next cell that contains a value. Basically, I'm trying to decrease the size of a selection (for the fill-down) by one cell in height. The specific cells and the spread between them will change periodically so, besides A5, I can't have this tied to specific cells. Here's my attempted code:
Range("A5").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FillDown
Selection.End(xlDown).Select
End Sub
Hopefully I'm clear with my explanation. I appreciate any help. Thanks
Range("A5").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FillDown
Selection.End(xlDown).Select
End Sub
Hopefully I'm clear with my explanation. I appreciate any help. Thanks