When your daily work consists of lots of document editing, you realize that every document format needs its own approach and in some cases specific applications. Handling a seemingly simple spreadsheet file can often grind the entire process to a stop, especially if you are attempting to edit with inadequate tools. To prevent this sort of problems, find an editor that will cover all of your needs regardless of the file format and delete highlight in spreadsheet with no roadblocks.
With DocHub, you will work with an editing multitool for any situation or document type. Reduce the time you used to devote to navigating your old software’s functionality and learn from our intuitive interface as you do the job. DocHub is a efficient online editing platform that covers all your document processing needs for any file, such as spreadsheet. Open it and go straight to productivity; no prior training or reading manuals is needed to enjoy the benefits DocHub brings to document management processing. Start with taking a couple of minutes to create your account now.
See improvements in your document processing immediately after you open your DocHub account. Save time on editing with our one platform that will help you be more efficient with any document format with which you need to work.
[Music] hey guys its dan strong with excel vba its fun today we have a quick question and in the question is basically we have a five by five grid and we need to take any cell that is highlighted in lets say yellow and were going to delete that row dynamically using vba so in this question we have just uh a through e and we have just one through five every time and when this report runs our user finds that theres certain ones that are yellow so were going to go ahead and do equals ray in between we just want to have some dummy data so how about between 1 and 1000 hit in parenthesis and then control enter thats going to populate all these and im going to go ahead and copy that ctrl c and right click sv thats s for special v for value and that will actually paste the real value so right click sv and now we have the permanent values escape key the permanent values in each of these so now we have some sample data im not going to actually run his report i dont even know what his