Originally Posted by stnkynts Union(Range(Cells(1, ActiveCell.Column), Cells(ActiveCell.Row, ActiveCell.Column)), Range(Cells(ActiveCell.Row, "A"), Cells(ActiveCell.Row, ActiveCell.Column))).Interior.ColorIndex = 3 Sorry, where do I put this? That was a little vague.
Union(Range(Cells(1, ActiveCell.Column), Cells(ActiveCell.Row, ActiveCell.Column)), Range(Cells(ActiveCell.Row, "A"), Cells(ActiveCell.Row, ActiveCell.Column))).Interior.ColorIndex = 3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks