| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Line selection from a cell script through a VBA macro
Hi!
I would like to make a selection through a complete data set by selecting lines based on the script in on cell of each line. for example: Line/Column: A B C 1 X1 2 Y1 2 X2 2 Y2 3 X3 5 Y3 4 X4 7 Y4 Say n: the line number, stating at n=1 I want the macro to start inside cell "B (n)", read the value, go to cell "B (n+1)" if cell "B (n)"= cell "B (n+1)" then erase line (n+1) Implement n = n+1 Start again if cell "B (n)" different to cell "B (n+1)" Implement n = n+1 Start again The result would be here taht line 1,3 and 4 are kept while the 2nd one is erased. It would be great if you can help me! Many thanks :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Expansion | Excel Worksheet Functions | |||
| Macro for cell selection starting with Last Cell | Excel Worksheet Functions | |||
| Macro help - copy a cell down | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
