Bashir,
not your immediate problem, but your code shows:

<snip
Message = "Insert the file name of the GAP rate sheet."
Title = "GAP02"
Default = "input file name with .xls"
GapName = InputBox(Message, Title, Default)
<snip
Windows(GapName).Activate
<snip

Without anything to open GapName, unless I'm missing something ??

Again, what error number are you getting ? And what is the value of
"rateSheet" ? maybe if you declared it as a string, it would help ?

NickHK

"intikhab bashir" wrote in message
...
This is a classic case of adopting someones code who left. The GapName
file is used below and holds the rates.

When the macro runs it just stops at the line with no error. It seems
to open the same file and then stop.

Thanks in advance,
Intikhab.

----------------
not a programmer
but trying!!!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!