Solved: find the FIRST used row and column

Code:

---

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

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

Code:

---

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

Code:

---

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

Quote:

---

Originally Posted by crmpicco

Code:

---

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