Run TIme error 91 Object variable or with block variable not set

**flex30** · 04-18-2013, 02:50 PM

Hi,

Im kinda new with excel and i need help with the error im encountering. I intend to use the code as a counter with 2 conditions one for the date and the second for the case indicated. Im getting the run time error 91 object variable or with block variable not set

Please Login or Register  to view this content.

**protonLeah** · 04-18-2013, 06:29 PM

The code you posted gives no clue what Program, DateStart, DateEnd are.

**flex30** · 04-18-2013, 06:53 PM

Hi i have attached a sample copy of the form,

Program is the name of the combobox and datestart and date end are the names of the date picker

Thanks,

**Norie** · 04-18-2013, 07:02 PM

When I run the code from the button it works fine, it's only when I try and run it from the VBE that the error occurs.

**flex30** · 04-23-2013, 11:23 AM

thats the issue im having, im not sure if there is something wrong with the code..

**Norie** · 04-23-2013, 11:34 AM

The problem is that you've given the Summary sheet the codename GetData, which is the same name as the button.

Change one of them, I changed the button's name to cmdGetData.

By the way, will you be running the code from the VBE?

PS If you do change the button name you'll need to rename the sub accordingly, eg cmdGetData_Click.