method of Range OBJECT GLOBAL failed for with range.

  • Hi Experts! I'm experiencing intermittent "The Following Error occured: Method 'Range' of object_Global" Failed from the below codes can some experts advise what's going on?

     With Range("V:AA")
                .Font.Color = vbBlack
                .Font.TintAndShade = 0
                .Font.Bold = False
                .HorizontalAlignment = xlCenter
                .VerticalAlignment = xlCenter
                '.Interior.ColorIndex = 0
    End With

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!