creating a UDF for copy

T

TG

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
 
S

Sheeloo

Try
Function copyCell(rng As Range) As String
copyCell = rng
End Function

but Excel already provides for that
simply say
=A1
in B1
 
S

Simon Lloyd

A function can only return a value not physically perform a copy, is
that what you really want?

TG;304001 said:
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
Click to expand...


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
Top