T Tom Ogilvy Feb 24, 2004 #2 assume the activecell is in the list, but not at the end activecell.End(xldown).select
R Ronbo Feb 25, 2004 #3 -----Original Message----- Click to expand... I am looking for a formula that will go to the end of a list and then one line below, this would be the next open line that I would like to paste info to. Using... Columns("B:B").Select ActiveCell.End(xlDown).Select takes me to the upper left cell that has contents. Any suggestions?
-----Original Message----- Click to expand... I am looking for a formula that will go to the end of a list and then one line below, this would be the next open line that I would like to paste info to. Using... Columns("B:B").Select ActiveCell.End(xlDown).Select takes me to the upper left cell that has contents. Any suggestions?
