Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Step through macro having different results to running macro

    When we run a macro here it works fine, the variable i is replaced each time the macro jumps to a new sheet. However, when we try and step through the macro - the variable does not seem to be replaced each time - which seems odd - and it ends up wanting to delete the wrong rows...which does not happen when we just run it.

    We are on Vista with Excel 2007.

    Anyone else seen this type of behaviour?
    Neil Eustice
    Woody Worshipper

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Nope. Would need to see the code.
    How are you testing the variable, by the way?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Does the variable depend on the currently active sheet? Maybe having the debugger running mucks that up.

    cheers, Paul

Tags for this 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
  •