Solved: find the FIRST used row and column

[crmpicco]

Last_Col = Cells.Find("*", SearchOrder:=xlByColumns, LookIn:=xlValues, SearchDirection:=xlPrevious).Column
Last_Row = Cells.Find("*", SearchOrder:=xlByRows, LookIn:=xlValues, SearchDirection:=xlPrevious).Row


i am using this code to find the LAST USED row/column,
is there code to find the FIRST USED row/column?

thanks.

Picco
http://vbaexpress.com/forum/images/smilies/107.gif

[Bob Phillips]

set rng = activesheet.usedrange
firstrow = rng.row
firstcol = rng.column

[crmpicco]

'... The First Column and First Row used in the sheet
Set Rng = ActiveSheet.UsedRange
First_Row = Rng.Row
First_Col = Rng.Column
Set Rng = Nothing


thanks xld

[crmpicco]

'... The First Column and First Row used in the sheet
Set Rng = ActiveSheet.UsedRange
First_Row = Rng.Row
First_Col = Rng.Column
Set Rng = Nothing


Is this the quickest way to do this?

i.E i notice i am setting an object

[Bob Phillips]

'... The First Column and First Row used in the sheet
Set Rng = ActiveSheet.UsedRange
First_Row = Rng.Row
First_Col = Rng.Column
Set Rng = Nothing


Is this the quickest way to do this?

i.E i notice i am setting an object

Whichever way you use, you will not be able to discern a difference, we are talking milli-seconds here.