Alaska Software Inc. - Show/Hide cells in Excel
Username: Password:
AuthorTopic: Show/Hide cells in Excel
Javier JareoShow/Hide cells in Excel
on Tue, 20 Nov 2012 18:01:34 +0100
Hello,

I have a problem to show / hide cells (rows / columns) in Excel.
The Excel Macro is like this :
        Range("A1:B2").Select
        Selection.EntireRow:Hidden = True / False
In Xbase++, I wrote :
        oRange := oSheet:Range("A1:B2")
        oRange.Select()
        and then, I try :
        - oRange:EntireRow:Hidden                   not work
        - oRange:EntireRow:CallMethod('Hidden',  ... )    not work

Can you help me, please?

Thanks in advance.
Javier Jareno Serrano  (from Spain)
AUGE_ OHRRe: Show/Hide cells in Excel
on Wed, 21 Nov 2012 04:15:10 +0100
hi,

>        Selection.EntireRow:Hidden = True / False
> In Xbase++, I wrote :
>        and then, I try :
>        - oRange:EntireRow:Hidden                   not work
>        - oRange:EntireRow:CallMethod('Hidden',  ... )    not work

as i can say "Hidden" is a Property, not a Method, so try :setProperty()

  oRange:EntireRow:setProperty('Hidden',  .T. )

greetings by OHR
Jimmy
Javier JareoRe: Show/Hide cells in Excel
on Wed, 21 Nov 2012 08:22:40 +0100
Thank you, Jimmy.
It works fine !!
(I was "in the moon". Of course, "Hidden" is a Property, not a Method).

Regards,
Javier Jareo Serrano

<AUGE_ OHR> escribi en el mensaje 
news:317e1262$2d67e6bd$18482@news.alaska-software.com...
> hi,
>
>>        Selection.EntireRow:Hidden = True / False
>> In Xbase++, I wrote :
>>        and then, I try :
>>        - oRange:EntireRow:Hidden                   not work
>>        - oRange:EntireRow:CallMethod('Hidden',  ... )    not work
>
> as i can say "Hidden" is a Property, not a Method, so try :setProperty()
>
>  oRange:EntireRow:setProperty('Hidden',  .T. )
>
> greetings by OHR
> Jimmy
>