Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping thru spreadsheets in a workbook
This one is a bit complicated and I understand if anyone
wants further clarification Scenario In an Excel workbook I have a login sheet which is hidden in Column A of the login sheet I Have a list of all the sheets in the workbook. ( say A1 thru A10) Currently what happens is when the workbook opens I have a piece of code which activates each individual sheet and then carrys out some action. then it goes to the next sheet and so on, this becomes a very lengthy process as the code can be quite long What I am looking for is code where it looks at the login sheet grabs the value in Cell A1 and carry's out the action then as long as there is a value in column A it will keep refreshing the sheets, ie it moves to cell A2 passes the sheet name back to the code and continues on. As soon as it comes across an empty value in Column A (ie column A11) it stops and exits the code. If you need further clarification please do not hesitate to email me Thanks in Advance Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximunm # of Spreadsheets in any Workbook | New Users to Excel | |||
creating a looping formula between different spreadsheets | New Users to Excel | |||
looping a calculation until workbook closes | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Looping Through Worksheets In A Workbook | Excel Programming |