Getting run-time error 1004

Hi friends,

Getting run-time error 1004

If user delete a district in cell P6 then I want to exit the sub. I’m getting error here.

I want to create a list of blocks in column ‘P’ after selecting a district in cell ‘P6’ dropdown list for districts.
After selecting a district I run a macro ‘block’ to get a list of blocks.

I’m getting run-time error after running a block macro.

Any help will be highly appreciated.

Thanking you,

Two problems: 1) if the wrong sheet is selected LR isn't set correctly and the cell content may be blank, and 2) if the right sheet is selected, the data (Mumbai city) contains a space. You can't have a space in a Named Range and, in fact, the Named Range has an underscore in it.

so, this will correct the second problem. I'll leave you to ensure the right sheet/data is selected.

Please Login or Register  to view this content.

Regards, TMS

Actually, the thread title is a little misleading as it's a run-time error rather than a compile error.

Regards, TMS

Hi TMS,

Greetings from me!

Perfect solution.

I by heart appreciated you for working on my problem since last two days. The problem was of _ only which you solved now.

Thank you and have a nice time.

You're welcome. Thanks for the rep.