Hiding row ?

[jodleren]

Hi all

Am I doing anything wrong here?

ws.Range(Trim(Str(j)) & ":" & Trim(Str(j))).Hidden =
True

It does not work for some reason....

Sonnich

 

[Jim Cone]

Yes, but you already knew that. Try...

ws.Range(Trim(Str(j)) & ":" & Trim(Str(j))).EntireRow.Hidden = True
'-or-
ws.Rows(j).Hidden = True
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30 different ways to sort in excel)




"jodleren" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

I would use Jim's
ws.Rows(j).Hidden = True

or
ws.cells(j,1).entirerow.hidden = true