Is this the book for me?

Dazed

New Member
Joined
Mar 18, 2003
Messages
27
I am currently using Excel 10 for Mac on Mac O/S 10. I need to know how to write and edit macros (since some of what I need can't be "recorded" in a macro). Does this book have what I need? I've not written macros since I recorded them in Lotus "back in the day". :D

Does it explain, for example, how to write code so that the user could select the file to import data from rather than it being hardcoded? Or what macro commands will work on a Mac but not on a PC? Thank you for any advice you have to offer!
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
There are three chapters of VBA examples, but nothing specific for a Mac.
 
I use Excel 2002 at work where I do all my hard-core Excel stuff (extensive formulas and now VBA). At home I use Excel 2001 on OS 9.2.2. I have tried a little at home, and while there are variations, it basically works the same. Seems that there are a few call procedures that are different, but can't give specifics right now.
 

Forum statistics

Threads
1,216,503
Messages
6,131,020
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top