problem unhiding columns

[Jack Fox]

I'm using the following C# code as I cycle through Excel worksheets to
unhide columns:

Excel.Range oRange = (Excel.Range) WS.Cells;
try
{
oRange.Activate();
}
catch
{
//...do stuff
}
oRange.EntireColumn.Hidden = false;

(WS is a worksheet object.) This works fine unless the first columns are
hidden, in which case it does not unhide the first columns. I have tried
various means to initialize my range in other ways, none of which have
worked.

(Can't remember why I'm doing the activate. It solved some problem along the
way.)

 

[mudraker]

Jack

I have only used vba drom within ecxel to reference excel worksheets s
i am guessing here.


have you tried

ws.Cells.EntireColumn.Hidden = False


before setting oRang

 

[Jack Fox]

That worked, thanks.