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