Results 1 to 11 of 11

Overflow Error While Selecting The Entire Worksheet

Threaded View

  1. #1
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Overflow Error While Selecting The Entire Worksheet

    I have following code in the worksheet and every time I select the entire worksheet it generates an "Overflow" error.
    Just curious to know why and if anything needs to be changed in the code to allow user to select the entire sheet.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count <> 1 Then Exit Sub
    If Target.Column = 2 Then Call detail_rep(Target.Row) ' Module 9
    If Target.Address = "$A$1" Then Call Summ ' Module 1
    
    End Sub
    Thanks for any suggestions.

    modytrane.
    Last edited by modytrane; 01-04-2012 at 03:09 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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