New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Operating System General OS operation information and support

Spreadsheet with Macros


Post Reply New Thread Subscribe

 
Thread Tools
Leonardo704

 
Member Since: Apr 04, 2014
Posts: 1
Leonardo704 is on a distinguished road

Leonardo704 is offline
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
QUOTE Thanks

Post Reply New Thread Subscribe


« Move disk space from hfs+ to ntfs | Delay app startup »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Numbers spreadsheet question: Fix OS X - Apps and Games 0 04-07-2014 03:14 AM

All times are GMT -4. The time now is 07:22 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?