PGalla06,
Check your syntax carefully. It looks like you are missing a
single quote ' before the ! in your formula.

Also you may want to use the Watch window to keep an eye on all your
variables.
Path, Company, Major Class, Dummy1 and Dummy2
Step through the code and make sure they are what you expect.

Also, I didn't see anywhere that you assigned Path and if you activate
the "Stewardship MACRO.xls" workbook then the Path will be different
than when the "DataEntryVar.xls" workbook is activated.

Hope this Helps


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=379509