creating a UDF for copy

's Computer Specifications

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 Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rules - creating copy	edn hello	Microsoft Outlook Discussion	3	26th Mar 2008 07:53 PM
Creating a Workbook Copy	nickm687	Microsoft Excel Programming	0	3rd Apr 2007 12:58 PM
Creating a back up copy.	sungen99	Microsoft Excel Programming	6	12th Oct 2005 06:02 PM
Creating distribution list with a copy to and blind copy to	=?Utf-8?B?Q29ubmll?=	Microsoft Outlook Contacts	2	1st Jul 2005 04:51 PM
Creating a backup copy	=?Utf-8?B?Um9iLUxNUw==?=	Microsoft Access Form Coding	4	3rd May 2004 10:51 PM