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