I have no idea how I got two Dim statements in the code. The
code should have only one Dim Statement.

Dim Var As Boolean
Var = Not Var


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> Ed,
>
> Use the Not operator. This will switch a boolean to its
> opposite. E.g,
>
> Dim Var As Boolean Dim Var As Boolean
> Var = Not Var
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
> news:[email protected]...
>> In Excel 2000 VBA, is there one single command to toggle a
>> Boolean - that
>> is, in whatever state it's in, change it to the opposite? I
>> know it can be
>> done with an If / Else - I was just wondering if there was a
>> singe-line way
>> to do it.
>>
>> Ed
>>
>>
>
>