| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array instead of loop I'm sure
Hi Howard,
Am Sun, 29 Mar 2015 15:28:47 -0700 (PDT) schrieb L. Howard: For i = 1 To UBound(varCheck) To this For i = 0 To UBound(varCheck) sorry, all other arrays had base 1. So I made this mistake. The further problem is transferring the data to a separate sheet to produce a more viewable and verifiable set of data. Do you want to cut matches and insert them offset(1,-1) and also transfer the matches to a new sheet? Or what data do you want to transfer? If all values from column A occure in the range C1:HQ950 you could copy column A and paste only the values. Then wraptext is false in the new list. Are some cells merged in the range C1:HQ950? And in column A also? Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop to add data in array | Excel Programming | |||
| Filling an array with a Loop | Excel Programming | |||
| loop with array | Excel Programming | |||
| Loop through array of worksheets | Excel Programming | |||
| Help with Loop / Array / Ranges | Excel Programming | |||
Threaded Mode
