| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two lists
K: how can you make the new list start in cell c6? I trie Range("c6...) but it does not ru -- halem ----------------------------------------------------------------------- halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993 View this thread: http://www.excelforum.com/showthread.php?threadid=26966 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comparing two lists
Using the original code, change from iRow = 0 to iRow = 5. Basically use iRow to hold the row to put the non-found items it. I increment i before I store, so the first one was C1. If you change to 5, the firs one will be C6. -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=26966 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two lists | Excel Discussion (Misc queries) | |||
| Comparing to lists | Excel Discussion (Misc queries) | |||
| comparing lists | Excel Discussion (Misc queries) | |||
| Comparing Lists | Excel Worksheet Functions | |||
| Comparing Lists to Partial Lists | Excel Programming | |||
![halem2[_43_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
