Results 1 to 5 of 5

Vba to set cells equal to these values

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Indiana, PA
    MS-Off Ver
    MS365 Version 2209
    Posts
    23

    Vba to set cells equal to these values

    Hello,

    I've attached a worksheet. I want a button that resets all of these cells to the values that currently live in them, no matter the edits to any of them, up to the point of clicking the button.

    The range of data is C6:V434, but there are cells in between these points that have formulas in them, so I can only effect the cells in the attachment that have values in them.

    Is there a way to more easily write this than referencing every cell and writing the code to set each cell equal to the respective value? There are 1746 datapoints on the spreadsheet and I can't imagine doing that.


    I really appreciate any help or advice that you can offer!


    Thank you,

    Will
    Attached Files Attached Files
    Last edited by billbalint; 03-05-2023 at 09:23 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to equal two cells if they have different values
    By mariosex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2018, 05:55 AM
  2. Multiple Cells values - formula to see which cells added together equal zero?
    By rodders0223 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2013, 11:09 AM
  3. If cell values equal, then merge cells
    By TonyforVBA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2013, 01:19 AM
  4. [SOLVED] Compare iF cells has equal values then.............
    By Oceans in forum Excel General
    Replies: 9
    Last Post: 11-07-2012, 09:13 AM
  5. [SOLVED] If cells Values are equal..........then
    By Oceans in forum Excel General
    Replies: 2
    Last Post: 11-07-2012, 05:47 AM
  6. Matching cells with equal values
    By LukeBhatia in forum Excel General
    Replies: 4
    Last Post: 09-14-2011, 11:19 AM
  7. checked the equal values from cells
    By kar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2006, 04:48 PM

Tags for this Thread

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