Opeations on xlSheetVeryHidden worksheet

[Frederick Chow]

Hi all,

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

Frederick Chow
Hong Kong.

 

[Tom Ogilvy]

Sure, but why not try it.

 

[Frederick Chow]

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

 

[Dave Peterson]

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

 

[Tom Ogilvy]

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