Results 1 to 1 of 1
  1. #1
    Spreadsheet with Macros

    Member Since
    Apr 04, 2014
    Posts
    1
    Spreadsheet with Macros
    I am not a macro coder or a MAC user. It is my wife's MAC. I can edit the VB code a bit but that is about it. I can also fumble my way around on the MAC. I am using an excel sheet with recorded macros on a MAC computer. The macros were recorded on a PC and I have run a similar spreadsheet on the MAC with no problem. The macro has been updated a bit since it was last run on the mac but the instruction that is hanging things up is one that has run before. It is a search and replace instruction and what is being searched for and replaced has changed slightly but not significantly. See code below:
    Range("C2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Range("D2").Select
    ActiveSheet.Paste

    [/B] Selection.Replace What:="am", Replacement:=" AM", LookAt:=xlPart, _
    SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False
    [/B]
    Selection.Replace What:="pm", Replacement:=" PM", LookAt:=xlPart, _
    SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False The highlighted code is where the macro hangs. Can anyone help? Thank you.
    Last edited by Leonardo704; 04-16-2014 at 03:10 AM. Reason: Yellow text not very readable

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macros for the Mac?
    By tadd5181 in forum OS X - Apps and Games
    Replies: 1
    Last Post: 01-20-2011, 12:42 PM
  2. Macros for the Mac?
    By tadd5181 in forum OS X - Apps and Games
    Replies: 5
    Last Post: 11-21-2010, 10:51 PM
  3. excel macros
    By fatfish in forum OS X - Apps and Games
    Replies: 2
    Last Post: 02-10-2010, 11:19 PM
  4. Office macros
    By chapjacobs in forum Running Windows (or anything else) on your Mac
    Replies: 1
    Last Post: 08-23-2008, 07:46 PM
  5. active x and macros
    By sandown42 in forum OS X - Operating System
    Replies: 5
    Last Post: 06-25-2008, 03:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •