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" wrote in message
...
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" wrote in message
...
Sure, but why not try it.

--
Regards,
Tom Ogilvy

"Frederick Chow" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Sure, but why not try it.

--
Regards,
Tom Ogilvy

"Frederick Chow" wrote in message
...
Hi all,

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

Frederick Chow
Hong Kong.