Opeations on xlSheetVeryHidden worksheet
 

Hi all,

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

Frederick Chow
Hong Kong.

Opeations on xlSheetVeryHidden worksheet
 

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.

Opeations on xlSheetVeryHidden worksheet
 

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.

Opeations on xlSheetVeryHidden worksheet
 

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

Opeations on xlSheetVeryHidden worksheet
 

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.