select above

[Kari]

is there a way to request that excel select all the rows
above the active row? For instance, if row 5 is the
currently selected row, excel would select rows 1 through
4.

Thanks

kari

 

[Frank Kabel]

Hi kari
try
....
if activecell.row > 1 then
range(rows(1),rows(activecell.Row-1)).Select
end if

 

[Kieran]

Untested, but I think something like
range("a1":Cells(Selection.row-1, selection.column).select

Should do it

 

[kari]

Worked like a charm! Thanks a bunch.