I have found a suggestion that an entire column can be defined as a named range, but that is not correct. By default it misses out the last row of data, and if you do extend it yourself to cover the last row and then delete a row, then it appears to lose an additional row (that is, I had a value in C1048576 that was being found in the vlookup, and when I deleted a row, it then failed to find the value in C1048575).
Phil Hibbs. -- Don't you just hate self-referential sigs? -- E-mail to [email protected] for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
