How do I select an undefined range of cells in Excel 2

[Jamie2002]

I want to write code to goto cell 114

Then select (as if you where holding down shift) end down, and end right, then go back up 1 line.

In english I want to select a block of data, of differing length, which always starts as cell c114, and once selected unselect the bottom 1 line.

Thanks.

 

[acron]

Try '

Range([I14], [I14].End(xlDown).Offset(-1, 0)).Select


AC

 

[Jamie2002]

Thanks.

 

[DaleWatson123321]

AC,

Useful contribution !!! ...and DESERVES more than a "Thanks".

...Dale Watson dwatson@bsi.gov.mb.ca

 

[Jamie2002]

Who asked you ?