ChDir "C:\gAMS_ZA-T-M\Reports\Downloads"
Workbooks.Open
Filename:="C:\gAMS_ZA-T-M\Reports\Downloads\Weekly_Report.xls"
RemoveRows'******** AT THIS POINT - ERROR *******

i'm no expert but when i insert another sub to run within one, i have
to use

Call RemoveRows

but maybe somebody else will find something different.
susan