|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
Hi
I recorded a macro to select all sheets, but it used the Array(1,2,3,4,) method with the sheet names.
I want to be able to select all sheets, but use the module in various workbooks, ie with varying amounts of sheets.
Can I do something like
p = Sheets.Count
v = Array(1, 2, -to p) ‘ how can i enumerate this?
Sheets(v).Select
or is there a nice simply way?
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
