February 11, 2015
I'm wondering if there is a book or website that will list the available codes that one can use when writing a macro. i'm just learning so I'm not sure what is out there. For example, when writing formulas you go hit the "FX" button and it will bring up all available functions to use. Is this available in the macro developer tab?
Also, is there a macro that can be written to only look at certain tabs(worksheets) in a workbook? For example I may have 20 different tabs(worksheets) inside of my workbook, but I need my macro to look at only the 4 of these?
thanks so much
October 5, 2010
VBA is a programming language so you really would need to learn the language in order to use it. It's not a case of listing 'codes'.
Have a look at this VBA Starter course to give you an introduction to it.
You can also look though Miscrosoft's MSDN site:
With regards to 'looking' at certain tabs (worksheets), if you can describe exactly what it is you want to do, we can probably come up with a solution. What are you trying to do on each sheet?
Most Users Ever Online: 57
Currently Online: Catalin Bombea, mymalone
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
John Ryan Kivela
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas