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

[Bob Phillips]

[vba]
set rng = activesheet.usedrange
firstrow = rng.row
firstcol = rng.column
[/vba]

[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.