While opening ods file having macro in which certain function uses value of sheet for its calculation it gives error object variable not set. This is due to variable being assigned value based on particular cell which is available when the workbook opens. But before opening it gives error.
Income Tax 2021.ods (179.2 KB)
Income Tax 2021.ods (179.2 KB)
