| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding a row | Excel Programming | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| Hiding #N/A | Excel Discussion (Misc queries) | |||
| Hiding Column Also hiding text | Excel Programming | |||
| Hiding #N/A | Excel Worksheet Functions | |||
Hybrid Mode
