Results 1 to 4 of 4

Object variable or With block variable not set Error during sorting program

Threaded View

BlahBlahBlahBlahBlah Object variable or With block... 04-17-2012, 07:19 AM
Andrew-R Re: Object variable or With... 04-17-2012, 07:30 AM
BlahBlahBlahBlahBlah Re: Object variable or With... 04-17-2012, 07:51 AM
royUK Re: Object variable or With... 04-17-2012, 07:57 AM
  1. #1
    Registered User
    Join Date
    04-17-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Object variable or With block variable not set Error during sorting program

    Hi,

    I'm a complete noob at VBA, and I cannot figure out why I am getting this error while trying to sort a list of numbers. I am trying to use ".Find" to select the maximum value in column H and then cut the row with this max value and the row above it into a new sheet. This process seems to work for most sets of numbers, but for some reason, with the particular set listed in the file, I get the error mentioned in the title. Obviously I am not setting something correctly, but I am not sure which variable needs to be set, and why some lists of numbers work whereas this particular one doesnt.

    file is attached


    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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