View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] wkwells@bellsouth.net is offline
external usenet poster
 
Posts: 6
Default Call a function within Excel VBA --- need help can't figure out syntax correctly

You are correct, the Cover Sheet will always be at the front of the
Workbook and never move. The List (Range) does not reference itself.

However, as a caviat, all Names in the Range may not actually be a
Sheet. Thus, will need a test as to if the Sheet(s) exist or not.

Not sure if it matters, but the Workbook does contain hidden sheets,
to the left of the Cover Sheet.

On Wed, 01 Feb 2012 14:56:48 -0500, GS wrote:

So then, all the sheetnames in the list are to follow the first sheet
(which contains the list), and any sheets not in the list remain in
their present order AFTER the reordered sheets?

Also, I assume the named range for the list has global scope (workbook
level as apposed to sheet level)?