Hi, I would like to know if there was a possibility to Select the value of a Workbook in a Second Workbook using VBA.
I don't have any code for that, I am starting from blank and still am blank. In more details, I have a certain value in a Workbook lets take "1234" as example int the range ("B67"). I would love with VBA to be able to Select that same Value in another workbook with VBA. I've found the function Cells.Find but can't do nothing with it because the result I get is a boolean value. I would like to be able to find the range of that second value. As an example, my value "1234" is in range"B67" for my first workbook. In my second workbook, the same value "1234" is in range"B34". I would like to know if there was any possibilities that VBA could analyse both of my workbooks and give me the answer that "1234" is in range"B34".
Please note that english is not my first language so there might be some mistakes in my post.
Thank you,
I don't have any code for that, I am starting from blank and still am blank. In more details, I have a certain value in a Workbook lets take "1234" as example int the range ("B67"). I would love with VBA to be able to Select that same Value in another workbook with VBA. I've found the function Cells.Find but can't do nothing with it because the result I get is a boolean value. I would like to be able to find the range of that second value. As an example, my value "1234" is in range"B67" for my first workbook. In my second workbook, the same value "1234" is in range"B34". I would like to know if there was any possibilities that VBA could analyse both of my workbooks and give me the answer that "1234" is in range"B34".
Please note that english is not my first language so there might be some mistakes in my post.
Thank you,