Macro works in 2010&2013 but not Excel 2003
This macro works for Excel 2010 and 2013, but not
Excel 2003. When I run it in Excel 2003 all the cells
(up to row 456) gets filled with #NAMN?
I'm trying to import data from the file called laget.xls
to idrott.xls where the macro resides. I'm using the
Swedish version of Excel 2003 so I guess NAMN
means NAME in English.
Please Login or Register to view this content.
Last edited by Mattiac; 02-08-2014 at 03:00 PM.
Thank you.
Last edited by Mattiac; 02-08-2014 at 03:00 PM.
Your recorded macro use the function IFERROR which works in Excel > 2003. You can use the IF(ISERROR fuvctions which works in all the Excel Editions.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Re: Macro works in 2010&2013 but not Excel 2003
Thank you so much for your quick and helpful answer, Fotis! :DOriginally Posted by Fotis1991
It solved the problem! I wish you a great weekend!
I'm now going to look for the setting so I can mark
this thread as solved.
PS. I just recently found about stars here so I
gave you a star of course! Better late than
never. Thank you very much again! :-)
..........................................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks