| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - format a range of cells as hyperlink?
Hi
I have a spreadsheet which contains the locations of some files starting at C2 and going down as far as required. What I would like to do is put some VBA code that either turns the text in C2:C? to a hyperlink to the file (preferred) or put a hyperlink to the file in D2:D?. I've tried but as yet with no success. Can anyone help? Thanks SteveB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells to Not Allow Hyperlink | Excel Discussion (Misc queries) | |||
| Hyperlink to range of cells | Excel Worksheet Functions | |||
| Format Cells - Hyperlink | Excel Worksheet Functions | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| reference format Range(Cells(),Cells()) | Excel Programming | |||
Threaded Mode
