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

You can't select cells on a hidden sheet. But that really
shouldn't matter because it is hardly ever necessary to select a
cell. Use a Range object variable instead.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"helmekki"
wrote in
message
...

Hi there

The sheet 2 should the activesheet, cuz the sheet1,where my
data, is
hidden.

i need to select the row in the sheet1 where my found result
(r) exist
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
--------------------


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread:
http://www.excelforum.com/showthread...hreadid=378424

Thank u , problem solved


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=378424