| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink function and copy the cells without the function
Usimg: 2003 version
In colA the names, and i colB the urls, and in colc the function =hyperlink(a1;b1) example: a1=google, b1=http://www.google.com/ The function is copied downi lC: OK Ptroblem: colC is to be copied elsewhere (each cell including both the text and Url) but not the function.(references) What to do? arnie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function or macro to copy cells... | Excel Discussion (Misc queries) | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| How to copy cells with HYPERLINK function? | Excel Discussion (Misc queries) | |||
| Copy Function into other cells | Excel Worksheet Functions | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Hybrid Mode
