Opeations on xlSheetVeryHidden worksheet

Hi all,

Can I perform operations, like sorting, on a xlSheetVeryHidden worksheet?
Thanks for your advice.

Frederick Chow
Hong Kong.

Sure, but why not try it.

--
Regards,
Tom Ogilvy

"Frederick Chow" <[email protected]> wrote in message
news:%[email protected]...
> Hi all,
>
> Can I perform operations, like sorting, on a xlSheetVeryHidden worksheet?
> Thanks for your advice.
>
> Frederick Chow
> Hong Kong.
>
>

Because why I sort on contents on XlSheetVeryHidden sheet, it causes a
run-time error unless I removed it.

Maybe I should try it again.

Frederick Chow

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> Sure, but why not try it.
>
> --
> Regards,
> Tom Ogilvy
>
> "Frederick Chow" <[email protected]> wrote in message
> news:%[email protected]...
>> Hi all,
>>
>> Can I perform operations, like sorting, on a xlSheetVeryHidden worksheet?
>> Thanks for your advice.
>>
>> Frederick Chow
>> Hong Kong.
>>
>>
>
>

Yes.

Just make sure you fully qualify your ranges and don't do any selecting.

with worksheets("hidden")
.range("a1:g99").sort key1:=.range("a1"), ....
end with

Frederick Chow wrote:
>
> Hi all,
>
> Can I perform operations, like sorting, on a xlSheetVeryHidden worksheet?
> Thanks for your advice.
>
> Frederick Chow
> Hong Kong.

--

Dave Peterson

Here is an example. Worked for me:

Sub TestSort()
Set sh = ActiveSheet
sh.Visible = xlSheetVeryHidden
Set rng = sh.Range("A1:F30")
rng.Formula = "=trunc(rand()*1000+1)"
rng.Formula = rng.Value
rng.Sort Key1:=sh.Range("B1")
sh.Visible = xlSheetVisible

End Sub

--
Regards,
Tom Ogilvy

"Frederick Chow" <[email protected]> wrote in message
news:[email protected]...
> Because why I sort on contents on XlSheetVeryHidden sheet, it causes a
> run-time error unless I removed it.
>
> Maybe I should try it again.
>
> Frederick Chow
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:[email protected]...
> > Sure, but why not try it.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Frederick Chow" <[email protected]> wrote in message
> > news:%[email protected]...
> >> Hi all,
> >>
> >> Can I perform operations, like sorting, on a xlSheetVeryHidden
worksheet?
> >> Thanks for your advice.
> >>
> >> Frederick Chow
> >> Hong Kong.
> >>
> >>
> >
> >
>
>