Search results for query: *

Thanks MakeItSo. The temp array worked best. I really appreciate the help. It is really nice to have other professionals to turn to. [thumbsup2]

Hello All, I am really confused on how to get the second highest value in a Access VBA array. I can get the highest value with the below code from the Microsoft website, but I can't find how to get the second and third highest values in different functions. Function Maximum(ParamArray...

Thanks Tony, It worked like a charm. kaprmg

Tony, Well, I keep getting runtime error 424 when I tested changing adjacent cells. I also tested areas above and below the cell range A7:A41 and get the same error. The code that you gave did exactly what was needed, but I have to continually push end on the error pop-up. When I try to...

Tony, You are awesome. That worked like a charm. What do you do if you wish to change the adjacent cells at a later time. Will this requires error handling? Thanks for all of your help. kaprmg

One other thing. I will want to be able to change what is in cell A7 at anytime and have it repeat the copy of what is on Sheet 2. Thanks, kaprmg

Hi Tony, I definitely want to copy the formatting as well as cell contents. As I understand it, VLOOKUP will only work with cell values. Thanks, kaprmg

Hi Tony, Thank you so much for your reply. In answer to your question, I named the cells in sheet 2 as "product" by highlighting the cells, and inserting a name. I then created a validation with drop down list referencing "=product" in the source area to keep it from getting confusing. This...

Help someone. I have 2 sheets in Excel 2002. Sheet 1 has a data validation on each cell from A7 to A41 that allows me to look at the values of A6 to A400 on Sheet 2. With the whatever I choose from the drop down list, I would like to paste the adjoining 6 cells from sheet 2 to sheet 1...