+ Reply to Thread
Results 1 to 4 of 4

Macro to retain data in Col E

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,737

    Macro to retain data in Col E

    I have written code to retain data containing the following text below in Col E, but cannot get it to work


    1) IG Voucher
    2) Annuity


    It would be appreciated if someone could kindly amend my code


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Howardc1001; 02-23-2021 at 11:10 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Macro to retain data in Col E

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,737

    Re: Macro to retain data in Col E

    Thanks for the help

    I can now see where I went wrong

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Macro to retain data in Col E

    Glad to help & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro fix space between data, Macro that takes cell information by name or data.
    By Maickol in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2015, 03:18 PM
  2. Macro template good saved but running macro with imported data problem
    By brazilexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2015, 10:42 PM
  3. automatic macro with linking data in two workbooks, multiple row data to one row data
    By garfield8626 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 01:47 PM
  4. [SOLVED] excel 2007 chart macro graphs data only from sheet on which macro was recorded
    By JW1028 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2013, 06:33 PM
  5. Macro to download monthly stock data and to refresh that data with the macro
    By Frankdude in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2011, 08:38 PM
  6. Creating a macro to auto-update external data and time macro was excecuted
    By UNWATCHABLE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 05:21 AM
  7. Optimizing Excel macro to find/replace with the list of data contained in the macro
    By Iceyburnz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2008, 08:41 PM

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