Recent content by seagreenTurtle

Thanks.

I have told you all that I know because my coworker just told me what I have described. If no one can help, I understand. As I mentioned I was just hoping for a few suggestions. For example, "use two nested for loops and and if statement to test if the cells are the ones to be skipped over"...

I don't know, probably alphanumeric data. I have just been hoping for some pseudocode for the routine, with detail about how to handle skipping the cells mentioned above. Thanks.

Thanks Ramou. I know that he has to process data from 96 well plates (microarray plates) but needs to skip the first two and last four cells. He needs to do this repeatedly for many plates and set up an application for a user to run repeatedly for many plates. Can it be done in Excel and...

sorry, there's a typo in my last reply. Access ABA should be VBA.

The problem is that a coworker just asked me verbally and did not give me details. I had hoped that I could find out some method or methods to load data from an array into an Access table from an array but an array with the first two and last four cells to be skipped. In my defense, I did say...

Thanks Remou but it needs to be done in Microsoft Access not Excel. Wouldn't using an array be the way to do it? Or is there a better way? Thanks.

A coworker is trying to process a matrix using VBA in Access. He asked how to use for (or for each?) loops to add data to the database but skipping the first two cells as well as the last 4. The matrix has columns 1 though 12 and rows A though H. Would he use nested for loops? Can he start...