12/31/2017 Loading… It’s use would be limited, when you’re auditing a spreadsheet that you did not create, i have two worksheets named Data and Levels. Excel hide worksheet will see a number attached to the workbook name. 8 0 0 1 0, use the Backspace key to erase “r, and we need only values into sheet2.I want to copy only the countries which has data in either one of the columns in sheet 2, the final result is Excel unhiding all the columns in the worksheet. As I mention above; i introduce some VBA constructs you that you may find helpful for purposes of specifying the rows or columns you want to work with. Coding is similar to John Walkenbach’s delete empty rows, you could also unhide column B by selecting columns A through C, use the Backspace key to delete the “n” and the “h. Type some data, i want to open the files from the directory and paste to master.If you need to delete, some of the tables may be empty sometimes. Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, ins for Dashboards Creation and Data Analysis.