Urgent, please help, code modification, find next, find, vba

Hi Guys,

I am new to VBA. I have been trying to develop a tool using VBA. For this tool I require to capture specific tags or numbers from one sheet and print the address of that specific number in another sheet. I am trying to pick these tags from an entire column from sheet 1 and print the desired tag address in the second sheet.

ISSUE:
I am able to find all the addresses of the required tags.
BUT while printing them in the second sheet. I am able top print it only one cell. I want each address to be printed in a different cell.

EXAMPLE:-

Lets say the addresses of the tags in sheet 1 are :A12,A13,A14,A15

While printing in second sheet : Lets say in Cell B1
It's printing as "A12,A13,A14,A15" in one cell B1
where as I want it to print as
Range("B1")=a12
Range("B2")=a13
Range("B3")=a14

And automate it using VBA.

I have attached the code below.

Your help would be really appreciated.

I have been trying too hard but nothing seems to work out.



Thanks in Advance,
Rohit

Please Login or Register  to view this content.

[/CODE]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
Then anyone will be able to help you.