If you start the operation by clicking one cell in your table area, then DigDB will automatically select all the neighboring area of that cell, this is equivalent of doing a Ctrl+Alt+* (select the current cell's neighboring area). Often, in a long table, the blank row may appear deep in the middle. Therefore, even though apparently the table is selected, the selection may have stopped at row 3,456 thus leaving out the rest 4000 rows.
Sometimes a table obviously contains blank. But users don't know how to operate on them, they ask us why aren't the entire table area selected when they invoke the commands.
The simple answer is that all blank rows needs to be deleted before doing any DigDB table operations. DigDB has a function that allows you to easily delete blank rows. You should use this function when you are not sure if a long table contains blank rows. You can select the entire area manually, then invoke this command, this command will tell you how many blank rows are there, and let you delete them if you want.
To get rid of the spaces, you can use DigDB trim function to trim a selected area, or an entire column. After the trim, you can be sure that there is no missed matches.
Copyright © 1999-2007 All rights reserved
Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user