error codes

Hello all, I have some code that has a successful OnError code that provides a message indicating that the file is currently in use by another user (error code 75 would normally populate). What I am trying to do however, is put an if statement in the error code so that if the error isn't...

Hi, i have the following macro which calculates the hours worked, money earnt and holiday pay accrued per month in a summary table, by using the month function on the date of each shift and adding up all the values from each month!! Sub ross() Dim i As Integer Dim n As Integer...

I use Add-Ins all the time and have the folders all added to the The error I am getting is "Cannot run the macro " xxx Macro Location xxx". The Macro may not be available in this workbook or all macros may be disabled." I developed the macro and add-in on this machine, and have used it...