I have some code that I have been using for more than a year. Excel VBA. Today it stopped working. I have no idea why. Here is the code:
Expand|Select|Wrap|Line Numbers
- Range ("E1").Select
- If IsEmpty(ActiveCell) Then Exit Sub
- Range(ActiveCell, Cells(Rows.Count, _
- ActiveCell.Column - 1).End(xlUp).Offset(0, 1)).FillDown
- End Sub
Please help! Thanks in advance.
I just tried it in a new workbook and it still works. Any ideas on why it won't work in the two workbooks I created yesterday? Thanks again.