Thank you so much. I do pretty well with VB but this is just different enough to confuse me. My boss does this kind of stuff all of the time and I think he just assumes that everyone else knows how.
Thanks again to DaleWatson and Tranpkp for all of your help!
Thank you guys so much. The code works but now I am getteing an error when there are no more cells that match my criteria. I tried to use error handling and it works to an extent but I have to push the OK button about 10 times.
Here is my code:
Sub Find()...
Sorry I didn't make it very clear that I need to check four specific cells to see if they are empty.
EX:
I will search column CY for cells that meet my criteria and
If the cell CY39 meets the criteria then I need to check X39:AA39 to see if they are empty. Then I need to mark them in some...
I am trying to read a text file (array) into access through VB. This is what I have but no matter what recordset function I try it doen't work. How do I get the information from one row and then move to the next record to get the info from the next row?
Here is what I have:
Do While Not EOF(1)...
I am trying to automate a process and am not having the best of luck. I need a macro to begin in a column and go down cell by cell until it finds a certain value. (this part I can do) Then I need it to go over (in the row of the cell with the value) and verify that four cells are not empty. If...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.