+ Reply to Thread
Results 1 to 4 of 4

Copying Cell Values

  1. #1
    Registered User
    Join Date
    08-16-2006
    Posts
    3

    Copying Cell Values

    I'm currently using a macro:

    Sub copyvalue()
    With Sheets("Capacity")
    .Range("O14").Value = .Range("BM4").Value
    End With

    End Sub

    But I'm very interested in getting any help to upgrade this to a function so that I do not have to run the macro to get the value copied from BM4 to O14.

    I appreciate your help in advance.

  2. #2
    Dave Peterson
    Guest

    Re: Copying Cell Values

    Check your other post.

    crabtrees wrote:
    >
    > I'm currently using a macro:
    >
    > Sub copyvalue()
    > With Sheets("Capacity")
    > Range("O14").Value = .Range("BM4").Value
    > End With
    >
    > End Sub
    >
    > But I'm very interested in getting any help to upgrade this to a
    > function so that I do not have to run the macro to get the value copied
    > from BM4 to O14.
    >
    > I appreciate your help in advance.
    >
    > --
    > crabtrees
    > ------------------------------------------------------------------------
    > crabtrees's Profile: http://www.excelforum.com/member.php...o&userid=37611
    > View this thread: http://www.excelforum.com/showthread...hreadid=572785


    --

    Dave Peterson

  3. #3
    Registered User
    Join Date
    08-16-2006
    Posts
    3
    Sorry...I need to keep the reference out of the cell so that it can't be written over.

    Thanks.

  4. #4
    Dave Peterson
    Guest

    Re: Copying Cell Values

    Then I don't understand why you can't use the subroutine.

    If you can't use a built in formula, I would expect that you wouldn't want to
    use a user defined function.


    crabtrees wrote:
    >
    > Sorry...I need to keep the reference out of the cell so that it can't be
    > written over.
    >
    > Thanks.
    >
    > --
    > crabtrees
    > ------------------------------------------------------------------------
    > crabtrees's Profile: http://www.excelforum.com/member.php...o&userid=37611
    > View this thread: http://www.excelforum.com/showthread...hreadid=572785


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1