runtime error 5

Dear Freidns, I want to get the language code of the running Excel of the user. So I put this code: Sub scheisstest() Dim LNG_USERLANGUAGE As Long LNG_USERLANGUAGE = Application.LanguageSettings.LanguageID(msoLanguageIDUI) 'Worksheets("UI").Cells(45, 1).Value = LNG_USERLANGUAGE End Sub...

this is a routine which makes a pointer turn around according to what angle is set by the user. When it goes to run it comes up with a runtime error 5. It used to work a few years ago but now it comes up with this error. The first macro listed below calls the second one up: Sub angulartilt()...

Hi, The following code is intended to loop through a list of dates, format them into "YYYY"-format, check if there's an identical item in the array yet, add any new items to the array and write it to a worksheet. It returns 'runtime error 5 invalid procedure call or argument', though. Private...

I have a macro that creates a PDF of a sheet in my workbook and saves it to a specific location. I created this workbook using Excel 2010 and the macro works fine. However, I need to use it on a different computer that has Excel 2007 and for some reason, I keep getting a VBA runtime error 5...

When debugging my codes the red line highlight for an error. Can anyone please help me to solve the issue. Thanks Application.ScreenUpdating = False Application.EnableEvents = False Call Filter_OFF Range("'[" & ThisWorkbook.Name & "]All Info'!A4:BB60000").Clear...

I pretty much changed few variable names from my old code. and i got "Run-time error '5': Invalid Procedure call or argument" on the red line. Im very new to this website, so please help me. Thanks in advance. -------------------------------------------------------------- Public Const...

Hello all, I have a macro that sends automated emails. I am not going to post the entire code because it is quite long... doing things like running of an excel sheet, dynamically updating the email text and a form word document, saving, printing, etc... but this macro worked for months. A few...