Jeffrey Smith
Well-known Member
- Joined
- Feb 11, 2005
- Messages
- 795
I imported many rows cells containing paths to locations on our server. If I edit the cell manually and do nothing but hit enter, Excel reformats the text as a link that I can click on and open a windows explorer screen at that location. Right now the text does not display as a link.
Without having to manually edit 20,000 cells, is there an easier way. I tried searching for some VBA code to actually edit a cell.
Thanks for any help.
Jeff
Without having to manually edit 20,000 cells, is there an easier way. I tried searching for some VBA code to actually edit a cell.
Thanks for any help.
Jeff