Forum Discussion
JohnTaylor20
Sep 12, 2024Copper Contributor
Match Cell Value with File Name in Folder Directory and get it's Path
asdf;kasdoiashdoiashdoiaushdioasjdas
MISAT
Why not simply
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=strFilepath, TextToDisplay:=cel.Value
Why not simply
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=strFilepath, TextToDisplay:=cel.Value
- JohnTaylor20Copper ContributorHansVogelaar im still getting mismatch error
- JohnTaylor20Copper Contributorthanks workde
If you keep on deleting your questions after they have been answered, you'll find that people will be less willing to help you!