Object variable or with block variable not set error in VBA

**Shanthan** · 03-20-2013, 11:02 PM

I have two worksheets, which are Sheet1 and Edit Log. I like to go from Sheet1 to Edit Log and enter some information in the last row in Edit Log. But, I am getting Object variable or with block variable not set runtime error.

Please Login or Register  to view this content.

Where am I doing wrong?

**Yraen** · 03-20-2013, 11:26 PM

You've got LastRow as a Range but are returning a row number to it which is a Long.

**Shanthan** · 03-20-2013, 11:31 PM

Thanks for the reply. I was getting Compile error: Object Required when I changed LastRow As Long. But, it worked when I set LastRow as Integer. I don't know why? Any ideas?