ActiveSheet
Hi,
I've set up a macro to open each of the individual cost centres within my company,extract specified data to a master file, and then close the individual cost centre file again. My cost centres are set in a list in cells A1 to A145. When I reach the last cost centre on the list (which is always named "SC.rpt") I would like to perform a slightly different routine. I would like the macro to either recognise that the file is the last in the list or recognise the file name if that file happens to be open. I was trying to use an "If" statement along the lines of ; If ActiveSheet = "C:\My Documents\SC.rpt" Then Any help appreciated or suggestions on better ways to proceed. Thanks Graham |
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com