#compileerror

Hi. I keep getting an error as Invalid Next control variable reference for my below code. Any help would be greatly appreciated. Option Explicit Sub ImportTable() Cells.Clear Dim OLApp As Outlook.Application Set OLApp = New Outlook.Application Dim ONS As Outlook.Namespace Set ONS =...

Hi, I have been trying to update the color of corresponding tabs when the table column containing the status is changed. I have written the following code to achieve the same: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("D:D"))...

Hello, My colleague has recorded a macro which works for 2 of our team. However when others try to use it they get a "Compile Error: Named Argument not found". I have done some research and I think I understand what a Named Argument is, but I don't understand how its created or why it works...