Compile error: Named argument not found (Foglio1 16:89) - Help With Referencing

[Mrmarc]

Hi all,

I have a sheet setup for scheduling of staff but when I download the 'RAW DATA Schedule' and dump it into excel its formatting is terrible to almost un-readable/unprintable. So I have setup another sheet 'Schedule' with nice formatting to print. I tried using Vlookup formulas and Index/Match formulas but nothing has worked so far so now looking at macros. I have a macro on the sheet but getting a compile error, can someone help?

What I am trying to achieve is for each name in column B. So B3:B17 the code runs and adds their scheduled stamps from 'Raw data schedule' and places it into the rows associated with that name. for instance for name B3 time stamps would be found in D3 - H3 and name B4 time stamps found in C4 - F4.

Only complication is the names from 'Raw Data Schedule' could change over the year and I really don't want to have to reset codes each time a name changes I wish to just change the name on sheet 'schedule and re-run the code each time the 'raw data schedule' is updated (Weekly updates to the 'raw data schedule')

I hope someone can help.

[jindon]

Try

Please Login or Register  to view this content.

[Mrmarc]

Unfortunately not,

Run-time error '429':

ActiveX component can't create object

Then when I modify and re-run

The macro ''Week X - Date Range - Date Range Template.xlsm'!Foglio1.Macro1' cannot be found.

[jindon]

What version of window/Excel?

[jindon]

Here's the workbook with my codes.
See if you still get error.

[Mrmarc]

I'm Running 2015.

Looks like code working but I get this error.

License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.

[jindon]

2015?
Is it Excel?

Your profile telling us 2007.

Anyway, if it is on Mac or other than Excel, it won't work.

[Mrmarc]

Yep, worked it out, was because of Mac. Easy enough to solve, install new XCODE and update VBA and it starts working on my Mac. Mac runs 2007, work runs 2015. Works on the work PC.

Thank you so much for your endless help, was excellent, I will go through the code the figure out where i went wrong.