"Set Range" failing. Maybe I just need to take a break from it

[wonderputz]

I've been plugging away at this pet project of mine for a few days, and for the life of me, I cannot get this one stupid little block of code to work:

Please Login or Register  to view this content.

I have 17 other subs running harmoniously with 36 worksheets, but "Set Range..." always manages to give me a problem. I clearly can't post thousands of lines of code or a 36-page workbook, so I will say that the "If" statement works; I can step through the code and the proper line will highlight depending on whether or not A1 is empty. I have startCell dimensioned as Range at the beginning of the Sub. I have tried Cells(1, 1) instead of Range with no luck. Maybe I'm just burning out and need to walk away from this for a few hours, but it's driving me crazy.

[JieJenn]

did you declare startCell as range?

Looks right to me. Easier if you can post the workbook

[wonderputz]

Ok, I ironed it out. Apparently I do need to take a break. The first error was generated by the next line to give startCell a value, which I managed to write wrong. The other error was from my forgetting how End(xlDown) works; with everything empty below A1, it never found another non-empty cell. I'm gonna go walk away from this for a little while. Thanks anyways.

[Norie]

Try coming from the bottom up.

Please Login or Register  to view this content.