+ Reply to Thread
Results 1 to 4 of 4

Delete cell contents not formula's

  1. 03-08-2024, 10:33 AM #1
    Tubtech
    Tubtech is offline
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Delete cell contents not formula's

    Is there a way, using a macro, to delete the contents of cells K10:K19 And Q10:Q19 and keep the formulas intact? Thanks.
    Reply With QuoteRegister To Reply
  2. 03-08-2024, 10:41 AM #2
    ByteMarks
    ByteMarks is offline
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Delete cell contents not formula's

    Try

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-08-2024, 05:00 PM #3
    Tubtech
    Tubtech is offline
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Re: Delete cell contents not formula's

    Thanks that was easier than I thought ! Works great!
    Reply With QuoteRegister To Reply
  4. 03-09-2024, 04:52 AM #4
    ByteMarks
    ByteMarks is offline
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Delete cell contents not formula's

    Happy to help
    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. Macro to delete cell contents based on other cell contents
    By SJCrawley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2021, 02:39 AM
  2. [SOLVED] Delete contents of a cell if another has any contents
    By new guy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2020, 02:25 PM
  3. [SOLVED] Delete contents of a cell in a given range if it matches contents of a specific cell
    By rcicconetti in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-13-2016, 06:46 AM
  4. Delete Rows that contain matching cell contents in column to the contents in cell B1
    By sspatriots in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2015, 05:39 PM
  5. [SOLVED] Delete cell contents but not formula?
    By dontaylor in forum Excel General
    Replies: 22
    Last Post: 10-22-2014, 03:44 AM
  6. [SOLVED] Code to delete cell contents IF the result of a formula in the cell = 0
    By jayjaynz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2013, 03:58 AM
  7. Find cell based on formula result and delete contents
    By Big Chris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2006, 10:07 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