Lartk
01-23-2013, 11:25 AM
Right now I have sheets referenced by their individual sheet names. For instance, sheet one is named "KL". Sheet 2 is named "AM". Sheet 3 is named "PP". And to flip from sheet to sheet i use
Sub KL ()
Windows("Fees.xls").Activate
Sheets("KL").Select
Application.Run "BLPLinkReset"
End Sub
This is not compatible becasue this macro will run on a couple different workbooks, and the sheet names change between workbooks. So instead of creating a whole new macro referencing new sheet names, I was wondering if I can start out by referencing the name of the first sheet of the workbook, like i have in the above code, but after that is there a code that will allow me to just go to the next sheet (I am trying to avoid referencing another sheet name and just say go to Sheet KL +1 (aka the next sheet in the workbook)?
Sub KL ()
Windows("Fees.xls").Activate
Sheets("KL").Select
Application.Run "BLPLinkReset"
End Sub
This is not compatible becasue this macro will run on a couple different workbooks, and the sheet names change between workbooks. So instead of creating a whole new macro referencing new sheet names, I was wondering if I can start out by referencing the name of the first sheet of the workbook, like i have in the above code, but after that is there a code that will allow me to just go to the next sheet (I am trying to avoid referencing another sheet name and just say go to Sheet KL +1 (aka the next sheet in the workbook)?