I have a column in a spreadsheet in which the cells will have value one of the following :
m = male,f = female
m = male^f = female
Note that there is space after and before equal to sign.
I need a macro which will check for all the cells in the column so that there is space after and before equal to sign. If a space is not there then that cell should be colured in red.
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.