Forum Discussion
Solved
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
If you keep on deleting your questions after they have been answered, you'll find that people will be less willing to help you!
Why not simply
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=strFilepath, TextToDisplay:=cel.Value
- thanks workde
- HansVogelaar im still getting mismatch error
