![]() |
|
#5
|
|||
|
|||
|
batman1,
Interesting approach and while I am close to making it work, the actual file is much larger and more complicated than my simple example. Two things: 1. There is not always a match. So when I run your code, Count and Ubound(result) are not the same. 2. So, I think that is why I get error about subscript out of range with Resize(count, 5). I can't upload the file here. It is too big. You can get it at the cross post link if your want to look. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Remove the subtotal columns in a sheet | Marcia | Excel | 3 | 12-01-2023 05:48 AM |
Relating cells in a row in one sheet to cells in columns on another sheet.
|
mbesspiata3 | Excel | 2 | 01-06-2017 05:42 AM |
Create a New Sheet from Existing Sheet with Specific Columns
|
malam | Excel Programming | 1 | 10-17-2014 10:01 PM |
From an XL sheet ,how to keep the group of columns which match with other XL sheet
|
Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |
| Removing columns within sheet | shabbaranks | Excel | 2 | 09-11-2012 05:03 AM |