| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
avoid multiple text in range
Hi Group,
Any hints how to approach this; Filling a range by code below. How to to code to skip if the same text in Worksheets(2).Cells(1, a) appears multiple times? a = Application.WorksheetFunction.CountA(Sheets(2).Ran ge("A1:K1")) + 2 Worksheets(2).Cells(1, a) = Worksheets(1).Cells(r, 2) Brgds CG Rosén |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How 2 avoid multiple IF's by LOOKUP's??? | Excel Discussion (Misc queries) | |||
| How to avoid multiple IF's by LOOKUP's? | Excel Discussion (Misc queries) | |||
| How to avoid duplicates across multiple worsheets in excel? | Excel Discussion (Misc queries) | |||
| How do I avoid multiple icons of Excel when using short command Al | Excel Discussion (Misc queries) | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Hybrid Mode
