Run-time error 91 Object variable or With block variable not set

[SKEEEETER]

Hi I have a sheet that certain input is added which then has formulas to calculate certain things.

I want to when click a button that it adds the contents of certain cells on the sheet into another table on another sheet. Once that has completed to then clear all the data that the user has imputed onto form.

Please Login or Register  to view this content.

I did have it all working but was cleaning up some things that and now get Run-time error 91 Object variable or With block variable not set.

I am hoping someone can point me in the right direction.

[Andy Pope]

The problem arises when listrows.count IS zero. It assign the value zero to lrow2, which causes an error when used as the row reference to DataBodyRange.

You need an else condition to perform some action when the listcount is zero.

[SKEEEETER]

Hi Andy thanks for your reply, I know something simple.

Where exactly would I put it?

[Andy Pope]

Not sure what you want to do if no rows currently exist, although I guess it would be to add a row and assign the count again to lrow2

Please Login or Register  to view this content.

[SKEEEETER]

Yes I have used the code before, it adds a row in table then adds the values into the table.

I have tried what you have suggested but still same error.

I have found that as had no data in table throws this error , as soon as there is data in the first row works ok.

[Andy Pope]

This change worked for me, but I don't know whether simply adding a list row is what your program requires.

Please Login or Register  to view this content.