Method 'Range' of object '_Worksheet' failed

**JSnow** · 03-25-2009, 03:33 PM

I have an interesting error that only happens when there is one row of data in the worksheet (sheet2 or "Half Payout"). Rows 1 & 2 are headers, row 3 is when the data starts - if any. With either no rows of data or more than one the coding works just fine. Here is the exact error message I'm getting: Run-time error '1004': Method 'Range' of object '_Worksheet' failed.

The following code is supposed to sort the rows of data when opened and then activate the first open cell below B2.

Please Login or Register  to view this content.

I appreciate any help on this. Long time searcher/first time poster.

**shg** · 03-25-2009, 03:36 PM

If there's only one row of data, gotorow points to one row beyond the end of the spreadsheet. Try it manually.

**JSnow** · 03-25-2009, 03:50 PM

Hmmm, I thought something like was happening. When I enter the code after the error and hover over the "gotorow" variable it gives me something like "row=65537".

I'd love to know WHY this is happening; however, I found a workable solution by pointing the range to B2 if B3 is not blank.

Please Login or Register  to view this content.

Thanks so much for the near immediate feedback.

**shg** · 03-26-2009, 04:33 PM

I'd love to know WHY this is happening;

That's why I suggested you try it manually. Select some cell with nothing below it and do Shift+Down (which is equivalent to what you're doing in code) -- it goes to the last row of the sheet.

**JSnow** · 03-27-2009, 10:42 AM

I'm not familiar with the manual method (I'm a newbie that reads alot). I clicked on open cell in column B and held Shift+Down; it highlighted the cell below - it didn't go all the way to the end row. Regardless, I appreciate your time shg.

**shg** · 03-27-2009, 11:45 AM

(I'm a newbie that reads alot)

Stick around, we'll fix that (the newbie part -- do continue to read ...)

Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes