Hello
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
Amy
Hi Amy,
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?
Regards
Phil
