Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get ActiveSheet to work... | Excel Discussion (Misc queries) | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet.Paste error | Excel Programming |