+ Reply to Thread
Results 1 to 3 of 3

Copying formulas from one range to another without using .copy and .pastespecial

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    63

    Copying formulas from one range to another without using .copy and .pastespecial

    Good Day,

    I'm curious if its possible to copy a range of formulas from one row to another row using vba, but without using .copy and .paste.

    This is what the code currently looks like:

    Please Login or Register  to view this content.
    it triggers whenever a value is entered in another column on that row. The formulas are also referencing other cells in whatever row they are pasted too.

    Is there another option aside from the code that I already have? I'd like to avoid copy and paste as well as select if possible.

    Thanks,
    Chris

  2. #2
    Forum Contributor
    Join Date
    04-01-2009
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: Copying formulas from one range to another without using .copy and .pastespecial

    Assumes the copy and paste sections are the same number of rows and columns...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-10-2010
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: Copying formulas from one range to another without using .copy and .pastespecial

    Excellent,

    Thanks for the help!

+ 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