Target Specific Array Elements Group

[dj44]

folks,

good day

how may i target the elements of the replace array

between 5 and 8




Sub Target_Array()


oSearch = Array(1, 2, 3)

oReplace = Array(A, B, C, D, E, F, G, H, i, j, K, L, M)

j=0
For i = LBound(oSearch) To UBound(oSearch)

For Each cel In ActiveSheet.Range("A1:A100").Cells

cel.Replace What:=oSearch(i), Replacement:=oReplace(i)


Next cel
Next i


End Sub



so that the result will be

F,G,H on the replace for 1,2,3


I need to set a j somewhere?

[Paul_Hossler]

Not exactly sure about what you want to do, but I don't think you need a j





Sub Target_Array()


oSearch = Array(1, 2, 3)

oReplace = Array(A, B, C, D, E, F, G, H, i, j, K, L, M)

For i = LBound(oSearch) To UBound(oSearch)

For Each cel In ActiveSheet.Range("A1:A100").Cells

cel.Replace What:=oSearch(i), Replacement:=oReplace(I+5)


Next cel
Next i


End Sub

[dj44]

Hello Paul,

oh yes that does make sense.

I want to replace from the 5th element onwards.

1 > E

2 > F

3 >G


my basic array replacement didint work - let me do some more experimentation