Hiding row ?
 

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

Hiding row ?
 

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"
wrote in message
...
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

Hiding row ?
 

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

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




On 01/12/2011 08:19, jodleren wrote:
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


--
Dave Peterson