Hi there
The sheet 2 should the activesheet, cuz the sheet1,where my data, i
hidden.
i need to select the row in the sheet1 where my found result (r) exis
in, so i used this line:
Code
-------------------
ThisWorkbook.Sheets(1).Cells(r, 1).EntireRow.Select
-------------------
but it gives me wrong msg: Select method of Range class Failed.
How can select the row without having to activate the sheet1
Code
-------------------
Sub t()
Dim r, o As Long
r = ThisWorkbook.Sheets(1).Cells.Find(What:=1).Row
ThisWorkbook.Sheets(1).Cells(r, 1).EntireRow.Select
End Sub
-------------------
--
helmekk
-----------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...nfo&userid=693
View this thread:
http://www.excelforum.com/showthread.php?threadid=37842