Problem cuz of Hidden sheet

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"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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
>