I need my Excel spreadsheet to have the ability to select the range from the active cell all the way back to cell A1. I've been writing code for this seemingly simple problem all day and nothing gets past the debugger. For example:

Range("A1":Range(ActiveCell)).Select

Can anyone help?

Danno