| Home |
| Search |
| Today's Posts |
|
#16
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete matching cells
Hi Ron,
My spreadsheet has: A B 0000000021957 0000000022002 0000000022002 0000000032002 0000000031957 0000000032003 0000000032002 0000000042002 0000000032003 0000000052002 0000000042002 0000000052003 0000000052002 0000000062002 0000000052003 0000000102002 0000000061967 0000000121996 0000000061968 0000000142002 0000000062002 0000000152002 0000000081963 0000000162002 Your macro (without Transpose) returns this: 0000000021957 22002 31957 61967 61968 81963 341991 401961 431978 482010 482011 In my spreadsheet: A2 contains 0000000022002 B1 contains 0000000022002 But your macro results contains 22002 Why are the leading zeroes being dropped? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all cells in range matching certain values | Excel Programming | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| DELETE ROW 3 MATCHING CRITERIA | Excel Programming | |||
| delete all matching rows | Excel Discussion (Misc queries) | |||
| Perform Lookup and delete non matching rows? | Excel Programming | |||
Threaded Mode
