| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a UDF for copy
Yes.
Thanks for pointing that out. "JMay" wrote: Wouldn't it be best to assign Function copyCell(rng As Range) As Variant ? "Sheeloo" wrote: Try Function copyCell(rng As Range) As String copyCell = rng End Function but Excel already provides for that simply say =A1 in B1 ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "TG" wrote: I would like to copy cell A1 to B1 without higlighting the cell and clicking copy. I would like to use a UDF to copy a cell. can anyone helomp me? Thanks in advance, TG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Copy/Paste Loop | Excel Programming | |||
| Creating a Workbook Copy | Excel Programming | |||
| Creating a back up copy. | Excel Programming | |||
| Creating a copy of a worksheet | Excel Programming | |||
| Creating a copy of a worksheet II (Just 2 more things please...) | Excel Programming | |||
![Sheeloo[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
