Fiill-in blank is not filling all cells

[AB33]

I got the below code from Mr excel and slightly ameded to my needs. It supposed to act like CNTL+ G and select blank. It is easy to do it in excel if it is one sheet. I would like to make the code dynamic so that I can only it in all sheets.

So, I have two questions: Why is the macto stops at line 18 and does not fill in the rest of the cellls? And How do I incorporate a loop for all sheets and cell which have the same strcture as the attached. The attached sample has all the requirments.

Thanks

Please Login or Register  to view this content.

[AB33]

Sorry! I did not attach a file

[jaslake]

Hi AB33

Change your definition of LR to this

Please Login or Register  to view this content.

from this

Please Login or Register  to view this content.

and that'll fix this issue

Why is the macto stops at line 18 and does not fill in the rest of the cellls?

I'll play with the loop to fix this issue (unless someone else posts first)

How do I incorporate a loop for all sheets and cell which have the same strcture as the attached

[AB33]

Jaslake!

That is great and thank you very much!

The first issue has now been resolved. I am looking forward to the second solution. Ideally the same function as go to special in excel, but with out choosing the blanks first and should also loop through all sheets.

Thanks again for your time and skills!

[jaslake]

Hi AB33

Try this

Please Login or Register  to view this content.

[AB33]

Jaslake!
That is great!
Thank you very much!

[jaslake]

Hi AB33

You're welcome...glad I could help. Thanks for the style points.