Searching referenced cells.

Quincy 0 Reputation points
2023-08-30T13:59:08.5666667+00:00

I have been using the .find function in VBA to parse through information to find what i need. When it comes to referenced cells it does not see the information. Every other sheet with the information hard coded works fine. Is there a way to search the referenced cells as the actual data without deleting the reference?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.