+ Reply to Thread
Results 1 to 4 of 4

Problems with sorting a dynamicly resizing range

Hybrid View

  1. #1
    Registered User
    Join Date
    07-22-2012
    Location
    The Shire
    MS-Off Ver
    Office 2013
    Posts
    51

    Re: Problems with sorting a dynamicly resizing range

    Huh... now that I look into it - "exe" is defined in the first loop, but then suddenly is "object required" the second time around, even though it is not present in the loop, itself.

    EDIT:
    Apparently changing

    "Offset(i - 1, 0)"
    to
    "Offset(i, 0)"

    fixes that problem, but why is beyond me. Especially since I needed the first time around to be Offset(0, 0). It's not that I cannot go around it, but it is peculiar, as hell.

    EDIT 2:
    After some fiddling, I have come to the conclusion it just doesn't like the "Offset(0, 0)" expression. Setting it to "Offset(i - 1, 0)" or "Offset(0, 0)" causes it to work fine the first iteration, but the second it no longer exists.
    Last edited by Durarara; 12-16-2015 at 10:00 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 06-24-2014, 09:27 AM
  2. [SOLVED] Problems with sorting andf Pivot Table problems
    By Saturn in forum Excel General
    Replies: 4
    Last Post: 10-07-2012, 07:47 AM
  3. Resizing cells in a selection without resizing entire sheet
    By Danielle via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 08-11-2006, 05:10 PM
  4. Problems with Command Buttons Randomly Resizing themselves
    By Blue Aardvark in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2006, 08:10 AM
  5. [SOLVED] resizing a range
    By don in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2006, 11:10 PM
  6. [SOLVED] resizing a range-What do I need to do to get the range to be resized as desired?
    By Tim Kredlo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2005, 04:05 PM
  7. Chart Resizing Problems
    By Pedro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2005, 11:06 AM

Tags for this Thread

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