Setting a range variable to its offset triggers an "Object required" error

Hello,

I have a tiny bit of code that behaves erratically and I cannot figure out why.

Please Login or Register  to view this content.

The problem lies with "Start_Cell.Offset(1,0)". For some reason "Set Start_Cell = Start_Cell.Offset(1, 0)" raises an "Object required" error.
The first "MsgBox (Start_Cell.Offset(1, 0))" works fine. Opening a new workbook, inserting a new userform and pasting the same code and entering "Start" in a cell have the same behaviour - it raises an error. Closing all Excel workbooks, opening a new one, inserting a userform, etc. works fine.

I also tried declaring another range variable and setting it to the offset, instead. I.e.:

Please Login or Register  to view this content.

Same error.

I am at a dead end. :/

You might have to attach a sample of your workbook with the userform and code in it. I copied and pasted the code you provided and it worked ok as long as the word start was in a cell.

There is a typo in your userform code
Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Not a problem....happens to a bunch of us.....I know I've done it a time or 10.