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" <PleaseRemoveThishkmusc@yahoo.com> wrote in message
news:%23p7iEZZJFHA.1308@TK2MSFTNGP15.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
news:e9JoqtZJFHA.4092@tk2msftngp13.phx.gbl...
> Sure, but why not try it.
>
> --
> Regards,
> Tom Ogilvy
>
> "Frederick Chow" <PleaseRemoveThishkmusc@yahoo.com> wrote in message
> news:%23p7iEZZJFHA.1308@TK2MSFTNGP15.phx.gbl...
>> 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" <PleaseRemoveThishkmusc@yahoo.com> wrote in message
news:uwuYc1ZJFHA.2136@TK2MSFTNGP14.phx.gbl...
> 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" <twogilvy@msn.com> wrote in message
> news:e9JoqtZJFHA.4092@tk2msftngp13.phx.gbl...
> > Sure, but why not try it.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Frederick Chow" <PleaseRemoveThishkmusc@yahoo.com> wrote in message
> > news:%23p7iEZZJFHA.1308@TK2MSFTNGP15.phx.gbl...
> >> Hi all,
> >>
> >> Can I perform operations, like sorting, on a xlSheetVeryHidden
worksheet?
> >> Thanks for your advice.
> >>
> >> Frederick Chow
> >> Hong Kong.
> >>
> >>
> >
> >
>
>