| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to look at all sheets not just specified sheet ?
I have been assisted with this code by some very helpful people, but i have
narrowed it down to these lines below that i need to modify slightly. How can i change the [Worksheets(4)] in (2)two instances below to refer to ALL(could be anywhere from 2-49) sheets in the workbooks instead ? If mybook.Worksheets(4).Range("B3").Value = input1 And mybook.Worksheets(4).Range("D3").Value = input2 Then mybook.Worksheets(4).Copy After:=basebook.Sheets(basebook.Sheets.Count) The 3rd instance of Worksheets(4)[Worksheets(4).Copy] needs to be the sheet that contains the 2 range values (B3" & "D3"), where the other 2 instances [worksheets(4)] need to refer to ALL sheets in the workbook. Regards Corey.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code to Add the same header from my first sheet into 20 sheets | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| copy and paste from different sheets into one sheet using a VB code | Excel Programming | |||
Threaded Mode
