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?


    Code
     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!

Register Yourself Login