Results 1 to 3 of 3

Overflow Runtime Error 6

Threaded View

  1. #1
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Overflow Runtime Error 6

    Hello,

    When I try to select all on a sheet by clicking the upper left box I get this error. Does anyone know why and how to fix please?

    Thank you

    debug at:

    If (Sh.Index < 4) + (Target.Count > 1) Then Exit Sub

    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
        If (Sh.Index < 4) + (Target.Count > 1) Then Exit Sub
        If Target.Column = 15 Then
            If Len(Trim(Target.Value)) = 0 Then
                Target.Value = "X"
            Else
                Target.ClearContents
            End If
        End If
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Runtime error 6: Overflow
    By jeetkapadia in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-04-2017, 05:40 PM
  2. runtime error 6 overflow??
    By nikko50 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2014, 02:36 PM
  3. [SOLVED] Runtime error 6 - Overflow
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2013, 08:12 AM
  4. Runtime Error 6 Overflow
    By wlugo13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2013, 02:22 PM
  5. [SOLVED] VBA runtime error '6': Overflow
    By clapforthewolfman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2013, 05:07 PM
  6. [SOLVED] Overflow Runtime error 6
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2013, 12:23 PM
  7. Runtime Error 6 Overflow
    By Wescotte in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1