Consulting

Results 1 to 2 of 2

Thread: Overflow Problem

  1. 07-05-2005, 03:44 AM #1
    snoopies
    snoopies is offline
    VBAX Regular
    Joined
    May 2005
    Posts
    94

    Overflow Problem

    Hi,

    May I know if there is any limitations of row?
    I encounter a problem saying that there is a overflow problem
    with following sentence..

    For I= .Cells(.Rows.Count, "A").End(xlUp).Row To 2 Step -1
    .......................

    Please advise...
    Reply With Quote Reply With Quote
  2. 07-05-2005, 04:35 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    As Long as I is declared as Long, not Integer, you should be okay.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules