+ Reply to Thread
Results 1 to 3 of 3

Roll column forward and hard paste previous

  1. 01-07-2022, 11:14 AM #1
    colin_dickson
    colin_dickson is offline
    Registered User
    Join Date
    11-04-2021
    Location
    London
    MS-Off Ver
    2019
    Posts
    3

    Roll column forward and hard paste previous

    Hi,

    I have the following code to copy a formula forward to the next blank column and hard paste the previous one:

    Please Login or Register  to view this content.
    Is it possible to change the row 76 in the range to the last used row in that range?

    Thanks
    Reply With QuoteRegister To Reply
  2. 01-07-2022, 11:33 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: Roll column forward and hard paste previous

    Try this
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  3. 01-07-2022, 11:38 AM #3
    colin_dickson
    colin_dickson is offline
    Registered User
    Join Date
    11-04-2021
    Location
    London
    MS-Off Ver
    2019
    Posts
    3

    Re: Roll column forward and hard paste previous

    Ideal - thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy last row to next blank row then hard paste previous
    By colin.dickson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2021, 07:24 PM
  2. [SOLVED] Copy formula down then hard paste previous row
    By colin.dickson in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-16-2021, 10:20 AM
  3. Find previous date in column and paste next column
    By Bubbleblue1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2021, 10:30 AM
  4. copy Formula & paste in same column next cell when previous column is not blank
    By sanjuss2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2020, 01:59 AM
  5. [SOLVED] Date Dependent VBA: copy formula to next column and paste values of previous column
    By elleb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-06-2020, 10:00 AM
  6. [SOLVED] Macro to Copy Formating from Previous Column and Paste into Last Column
    By rmmohan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 09:37 AM
  7. Changing figures to XX for a ''roll forward'
    By aaaaaaiden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2013, 09:08 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1