Do you need a fast and simple way to copy code in blank? Your search is over - DocHub gets the job done fast, with no complicated application. You can use it on your mobile phone and PC, or internet browser to edit blank anytime and anywhere. Our versatile software package includes everything from basic and advanced editing to annotating and includes security features for individuals and small businesses. We also provide tutorials and guides that aid you in getting your business up and running without delay. Working with DocHub is as simple as this.
Simple, right? Better still, you don't need to be concerned about information safety. DocHub delivers quite a number of features that help you keep your sensitive data risk-free – encrypted folders, two-factor authorization, and more. Enjoy the bliss of reaching your document management objectives with our professional and industry-compliant platform, and kiss inefficiency goodbye. Give DocHub a try right now!
Hey. Welcome back to the MrExcel netcast. Im Bill Jelen. Great question came in. The person was trying to write some VBA code that would go through and find all the non-blank cells in column I and write them to another column -- lets say, column K -- and youll see here in our data, most of these records are blank but, every once in a while, we have a code thats over here, and I love this particular macro because this is one macro that the macro recorder can actually get correct. So, Im going to turn on the macro recorder. TOOLS, MACRO, RECORD NEW MACRO. Ill call it GETCODES, no space of course in the MACRO NAME, stored in THIS WORKBOOK, well click OK. Well, were going to use some built-in functionality here. Im going to turn on the auto filter -- DATA, FILTER, AUTOFILTER -- and then, in column I, all the way at the bottom, theres a couple of interesting options -- one called blanks and one called non-blanks. Im going to choose the non-blanks, and youll see that we have all
