dj44
11-09-2017, 09:53 AM
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?
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?