You are here:
Formulae in Excel. VB Macros.. Though not really expert in this.
About 8 years
B.Tech.
Everytime you look at Excel there is more to learn... It is amazing!
Master VB Macros, Learn Pivot Tables/Charts
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Sirajuddin | 06/08/09 | 10 | 10 | 10 | 10 | |
| Kurt | 01/28/09 | 10 | 10 | 10 | 10 | Great solution! |
| charlie | 01/23/09 | 10 | 10 | 10 | 10 | smart and clear solution |
| BhagyaSree | 01/22/09 | 10 | 10 | 10 | 10 | Thank You so much... |
| Balasubramanian | 01/21/09 | 10 | 9 | 10 | 10 | This is the first time, I am ..... |
I am sure MACRO can be written but my first effort would be to avoid MACRO and achieve it by Formulae. MACROs have their own disadvantages. So, tell me -- (1) How many combinations of values AO vs
You will need to -- Worksheets("Sheet1").Select Cells (i,j).select -- Replace i / j with your cell numbers Worksheets ("Log Sheets").select Cells (k,l).select -- Replace k / l with your cell numbers
1. Create a button and assign Macro. Click the button to run. 2. If you are using Excel 2003 or before, add a custom button to tool bar ,assign macro to it, click to run. 3. Tools, Macros, select macro
Answer is yes. Check box results are linked to a cell. If you have not done it do it by maintaining properties of check boxes. then, you need to create a count of TRUEs. Based on this count, you can
Vinod, (1) Firstly, there is no cell A in excel. A is a column. The cells are specified as A1, B5 etc. So you need to give exact requirements. (2) Please let me know the exact Excel Version you are using
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.