+ Reply to Thread
Results 1 to 5 of 5

Macro to clear cells upon opening

  1. 04-06-2017, 03:50 AM #1
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Macro to clear cells upon opening

    Hi

    I would like a macro that upon opening the spreadsheet it would:

    Go to sheet: “Open FP&A BR Actions Log” and clear cells AB5 and AB6

    Can anyone help please?

    Regards

    Paul
    Reply With QuoteRegister To Reply
  2. 04-06-2017, 04:21 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,430

    Re: Macro to clear cells upon opening

    Does this work:

    Please Login or Register  to view this content.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 04-06-2017, 04:57 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,430

    Re: Macro to clear cells upon opening

    No. it doesn't. This does. Paste into the This workbook window.

    HTML Code: 
    Adjust ranges, etc, to suit.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-06-2017, 08:09 AM #4
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Macro to clear cells upon opening

    Thanks Glen - I changed the code and it worked!
    Reply With QuoteRegister To Reply
  5. 04-06-2017, 08:15 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,430

    Re: Macro to clear cells upon opening

    Hi. you're welcome...
    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. [SOLVED] Macro to clear cells in range & move up if certain cells meet criteria
    By samder68 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2016, 10:52 PM
  2. [SOLVED] VBA macro to clear all cells but ignore locked cells
    By k1989l in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2015, 07:27 AM
  3. Macro - find cells row by row, clear contents if certain value in cells
    By astrbac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2014, 05:34 AM
  4. [SOLVED] Macro to clear certain cells in the row if first cells date is in the past
    By davorin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 04:19 AM
  5. [SOLVED] Clear contents of cells on opening workbook
    By jason1970 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2013, 09:42 AM
  6. Clear Cells Without Macro
    By Bobbbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2010, 04:41 PM
  7. Macro to clear cells
    By Esrei in forum Excel General
    Replies: 5
    Last Post: 04-19-2005, 09:06 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