Globally Check Contents Of Table

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have linked to an Excel spreadsheet with 15 columns. The cells in the
worksheet should only contain a cap X or be blank. Lowercase x is also
acceptable. ("" is not acceptable) Is there a way to globally check the entire
linked table to see if there is anything else but an X, x or blank in any cell
in the table or does this need to be done column by column?

Thanks!

Tom
 
The manual find in Access (the one you get when clicking the binoculars button on the
toolbar) has the option to search an entire form or table for an item. To do it from code,
you would need to do a FindFirst/FindNext on each column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
Need Macro... 8
Excel Concatenate with line breaks but ignore blank cells 3
Excel MS Excel - MS Office 2010 0
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Disappearing Cell in table 3
easiest way to find next non blank row 5

Back
Top