Re: Hidden Column

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the help, but it did not work.

What I am trying to do if run an if statement, ie if the column is hidden
then run a procedure, if it is false, then run a different procedure.

The start of the if statement i would like to use, is:

sheets("money in").column(lastbank+2)

Can you help with this?

Jason

"JE McGimpsey" wrote:

> One way:
>
> Public Sub IsItHidden()
> MsgBox IIf(Columns(3).Hidden, "", "Not ") & "Hidden"
> End Sub
>
> Change column number to suit.
>
>
> In article <A6B24376-7FE6-427A-A426-C152D87AC932@xxxxxxxxxxxxx>,
> Ashman <Ashman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > G'Day all,
> >
> > I have a quick question. In a worksheet I have a column which sometimes is
> > hidden.
> >
> > How do I use a macro to detect if the column is hidden or not?
> >
> > Any help would be much appreciated.
> >
> > Thanks
> >
> > Jas
>
.

Relevant Pages

  • Re: Worksheet copy speed
    ... Well thats the problem you see, its not the code that is too slow. ... macro. ... but it it still not as fast as when the worksheet had no macros ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • importing multiple text files into the same worksheet
    ... I would like to run a macro which will firstly open a file selection box ... then each one would be appended to the same worksheet. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Worksheet Deactivation Event
    ... I am trying to enable a macro to run when a particular worksheet is ... Thus far I have followed the directions on this web page: ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Use Range Name in Macro
    ... stored in the worksheet) in a macro? ... Chris ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Hidden Column
    ... In a worksheet I have a column which sometimes is ... How do I use a macro to detect if the column is hidden or not? ... Jas ... Prev by Date: ...
    (microsoft.public.excel.programming)