Find & Replace VBA - read txt in cell in column A, find if same exists in any cell in column C, replace it with txt found in adjacent cell in column B

[abramo]

In past had found solution to issue, requested by another member and published in mrexcel, but I cannot locate it any more. So here is my request for Macro:

Find & Replace macro :
EVERYTHING IS IN A SINGLE SHEET

- read txt in cell in column A
- find if same txt exists in *any* cell in column D (loop all D)
- write new txt in cell in column C euqal to txt found in cell in B which is adjacent to our cell in column A (pairs A / B contain FIND (A) and REPLACE BY (B)
- repeat by next cell in column A
- end when ALL cells in column A have been dealt with

MREXCEL-find-replace-2023-03-23-A.xlsx
	A	B	C	D
1	CATEGORY-ORIGINAL	Category-processed	Category-processed	CATEGORY-ORIGINAL
2	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers	Compressor Air & Water Aftercoolers	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
3	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories	Air Compressor Accessories	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
4	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits	Air Compressor Separator Kits	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
5	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits	Air Compressor Parts Kits	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
6	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks	Air Compressor Portable Air Tanks	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
7			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
8			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
9			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
10			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
11			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
12			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
13			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
14			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
15			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
16			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
17			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
18			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
19			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
20			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
21			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
22			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
23			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
24			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
25			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
26			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
27			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
28			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
29			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
30			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
31			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
32			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
33			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
34			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
35			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
36			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
37			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
38			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
39			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
40			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
41			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
42			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
43			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
44			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
45			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
46			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
47			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
48			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
49			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
50			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
51			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
52			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
53			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
54			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
55			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
56			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
57			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
58			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
59			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
60			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
Sheet1

Explanation of example:
Columns A and B contain the pairs of FIND (col A) and REPLACE BY (col B)
Column D contains the original texts to be replaced
Column C contains the end result provided by the Find & Replace process

Hope some kindred spirit may assist here.
Thanks!

PS: OUCH : title of thread wrong! Should read:
Find & Replace VBA - read txt in cell in column A, find if same exists in any cell in column D, replace it in C with txt found in adjacent cell in column B

 

[igold]

How about this:

Sub Categories()

    Dim arr
    Dim lCell As Range, i As Long, d As Long
    Set lCell = Cells(Cells.Find(What:="*", SearchOrder:=xlRows, _
        SearchDirection:=xlPrevious, LookIn:=xlFormulas).Row, _
        Cells.Find(What:="*", SearchOrder:=xlByColumns, _
        SearchDirection:=xlPrevious, LookIn:=xlFormulas).Column)
    arr = ActiveSheet.Range("A2:D" & lCell.Row)
    For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row - 1
        For d = 1 To UBound(arr)
            If arr(i, 1) = arr(d, 4) Then arr(d, 3) = arr(i, 2)
        Next
    Next
    ActiveSheet.Range("A2").Resize(UBound(arr, 1), UBound(arr, 2)) = arr
    
End Sub

 

[abramo]

Many thanks @igold - by testing I get error "Object variable or with block variable not set"
I'll be damned if I understand the meaning of this!
Any ideas?
Thanks!

 

[abramo]

deleted

 

[igold]

Are you all set or are you getting errors...

 

[abramo]

Yes, by testing I get error "Object variable or with block variable not set"
The code does not perform.

 

[igold]

Which line is giving you the error. The code worked flawlessly on the data you provided in the OP. Have you altered the code at all...

 

[abramo]

Thanks, I just copy/pasted the code without any intervention.
Upon running the macro I immediately get error box with the error "Object variable or with block variable not set"
I run the macro on exactly the same sheet provided here.
As the code has performed ok for you, I have to check any issues locally.
I will revert when ready, tomorrow.

Meantime, thanks again - have a nice day.

 

[igold]

With this data:

Categoris.xlsm
	A	B	C	D
1	CATEGORY-ORIGINAL	Category-processed	Category-processed	CATEGORY-ORIGINAL
2	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers	Compressor Air & Water Aftercoolers		Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
3	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories	Air Compressor Accessories		Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
4	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits	Air Compressor Separator Kits		Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
5	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits	Air Compressor Parts Kits		Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
6	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks	Air Compressor Portable Air Tanks		Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
7				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
8				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
9				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
10				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
11				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
12				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
13				Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
14				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
15				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
16				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
17				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
18				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
19				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
20				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
21				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
22				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
23				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
24				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
25				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
26				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
27				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
28				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
29				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
30				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
31				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
32				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
33				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
34				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
35				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
36				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
37				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
38				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
39				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
40				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
41				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
42				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
43				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
44				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
45				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
46				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
47				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
48				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
49				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
50				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
51				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
52				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
53				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
54				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
55				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
56				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
57				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
58				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
59				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
60				Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
Sheet1 (3)

this code:

Sub Categories()

    Dim arr
    Dim lCell As Range, i As Long, d As Long
    Set lCell = Cells(Cells.Find(What:="*", SearchOrder:=xlRows, _
        SearchDirection:=xlPrevious, LookIn:=xlFormulas).Row, _
        Cells.Find(What:="*", SearchOrder:=xlByColumns, _
        SearchDirection:=xlPrevious, LookIn:=xlFormulas).Column)
    arr = ActiveSheet.Range("A2:D" & lCell.Row)
    For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row - 1
        For d = 1 To UBound(arr)
            If arr(i, 1) = arr(d, 4) Then arr(d, 3) = arr(i, 2)
        Next
    Next
    ActiveSheet.Range("A2").Resize(UBound(arr, 1), UBound(arr, 2)) = arr
    
End Sub

Returns this:

Categoris.xlsm
	A	B	C	D
1	CATEGORY-ORIGINAL	Category-processed	Category-processed	CATEGORY-ORIGINAL
2	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers	Compressor Air & Water Aftercoolers	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
3	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories	Air Compressor Accessories	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
4	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits	Air Compressor Separator Kits	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
5	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits	Air Compressor Parts Kits	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
6	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks	Air Compressor Portable Air Tanks	Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
7			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
8			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
9			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
10			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
11			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
12			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
13			Compressor Air & Water Aftercoolers	Compressors, Air Tanks & Pneumatic Tools > Air and Water Aftercoolers
14			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
15			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
16			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
17			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
18			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
19			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
20			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
21			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
22			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
23			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
24			Air Compressor Accessories	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories
25			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
26			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
27			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
28			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
29			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
30			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
31			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
32			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
33			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
34			Air Compressor Separator Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Compressor Separator Kits
35			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
36			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
37			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
38			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
39			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
40			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
41			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
42			Air Compressor Parts Kits	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Parts Kits
43			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
44			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
45			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
46			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
47			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
48			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
49			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
50			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
51			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
52			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
53			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
54			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
55			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
56			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
57			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
58			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
59			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
60			Air Compressor Portable Air Tanks	Compressors, Air Tanks & Pneumatic Tools > Air Compressor Accessories > Portable Air Tanks
Sheet1 (3)

 

[abramo]

Thanks - you got this 100% correct!
Now I have to find out why locally I get an immediate error box at the worksheet upon running - while I get no error indication at VBA code debugging.