ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VB Script: Code for "Sheets in selection" (https://www.excelbanter.com/excel-discussion-misc-queries/130072-vbulletin-script-code-sheets-selection.html)

J@Y

VB Script: Code for "Sheets in selection"
 
What would be the code for something like this argument:

For each sheet in sheets selected, DO
....
....
next
end

Dave Peterson

VB Script: Code for "Sheets in selection"
 
Dim wks as object
for each wks in activewindow.selectedsheets
'...
next wks



J@Y wrote:

What would be the code for something like this argument:

For each sheet in sheets selected, DO
...
...
next
end


--

Dave Peterson


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com