MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I should know this one..........


Posted by Paul Magruder on July 10, 2001 8:27 AM

Just as...
Selection.End(xlDown).Select will take you to the last data point in a column, what is the commmand to go to the last data point in a row? I have tried
Selection.End(xlacross).Select and Selection.End(xlright).Select ...but they don't work.

Thanks
Paul


Posted by Barrie Davidson on July 10, 2001 8:39 AM

Selection.End(xlToRight)

Barrie

Posted by Paul Magruder on July 10, 2001 9:49 AM

Thanks.... Just what I needed