Object variable or with block not set error shows when running from vba not from macro button

[QuestionBaker]

I use find method to find column number.
If I run the code from a button that is present in the sheet, the code runs fine
If I run the same code via visual basic, it throws an error saying object variable or with block not set.
Has anyone else encountered this type of problem before?

 

[Michael M]

It might pay to post the code you are using.

 

[QuestionBaker]

The actual code is way too big but the error was occurring on the following line

j_start = deliver.Range("A1:XFD1048576").Find(what:=CDate("1/" & MonthName(DatePart("m", next_stone)) & "/" & DatePart("yyyy", next_stone))).Column

but the error has stopped occurring now. IIRC the only changes I did was add some spaces where I define public variables.
Plus, I recovered an older version where the error was not occurring and updated the code over there while checking line.
The problem is resolved, but I don't know what led to the solution.

 

[Michael M]

Glad to hear that you resolved the issue.
But I would consider making changes to your ranges !!
If you have a few of these Range("A1:XFD1048576") it could slow down you code significantly.
Surely you aren't using EVERY cell in the sheet !!
Look at changhing to something like UsedRange or CurrentRegion instead

 

[QuestionBaker]

thanks, I will use a more restricted range.

 

[Michael M]