| Author | Topic: Show/Hide cells in Excel |
---|
| Javier Jareo | Show/Hide cells in Excel
on Tue, 20 Nov 2012 18:01:34 +0100Hello,
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_ OHR | Re: Show/Hide cells in Excel
on Wed, 21 Nov 2012 04:15:10 +0100hi,
> 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 Jareo | Re: Show/Hide cells in Excel
on Wed, 21 Nov 2012 08:22:40 +0100Thank 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
> |