Hello! Can someone show how to do this in VBA?

Example.

Range 1 is from A2:D8 . e.g. A2=1

Range 2 is from A10:J1000 . e.g. J1000=1

I want to convert J1000=A2.

I need to convert all the individual cell value of range 2 to the cel
address of range 1 if the value in range 2 is equal to the value i
range 1.

Regards,
Michae

--
Message posted from http://www.ExcelForum.com