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.