Results 1 to 2 of 2

Selection.Replace Alternative (Excel 2013 Compatiblity)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-09-2015
    Location
    Virginia, USA
    MS-Off Ver
    Excel 365
    Posts
    129

    Selection.Replace Alternative (Excel 2013 Compatiblity)

    I have a macro that was written in modern day Excel. Sadly, I am trying to share this macro with a friend that has Excel 2013 but it keeps crashing on anything with Selection.Replace.

    Is there an easy way to make my code backwards compatible or to know exactly what Excel 2013 doesn't like about the below statement?

    Selection.Replace What:="@DC", Replacement:="DC", LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=True, FormulaVersion:=xlReplaceFormula2
    Thanks!
    Last edited by rjj920; 02-11-2021 at 08:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Senders Email Address: Outlook 2013 to Excel 2013 Not Working
    By Excel-Access in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2018, 09:48 AM
  2. Excel Upgrade to 2013, Macro runs erratically with macro assigned to button (shape)
    By sspatriots in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2016, 07:23 PM
  3. Connecting Excel 2013/16 to Access 2013/16 (SELECT, INSERT, and UPDATE)
    By mrb783 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2016, 03:04 PM
  4. instal stand alone EXCEL 2013 on OFFICE 2013 home and business
    By LukasLyziciar in forum Excel General
    Replies: 0
    Last Post: 06-19-2015, 03:41 AM
  5. Excel 2013 and Access 2013 as Pivot Table External Data Source
    By Grimnebulin in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-27-2015, 02:13 PM
  6. Replies: 1
    Last Post: 12-27-2014, 11:20 PM
  7. Replies: 3
    Last Post: 07-20-2014, 11:46 AM

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