Hi Dave, and happy new year to all of you! I read about "your reference to worksheets at the top of the module".I think this sounds really interesting, can you give us an example of how you do this and how it is useful.Thanks a lot! Regards Torstein Also, I like to use references to worksheets, etc, rather than multiple
Sheets("xx") calls. I simply set them up at the top of the methods and use
them to explicitly specify which item I'm working with.
Regards, Dave S
---------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now. <img width="1" height="1" alt="" src="http://us.bc.yahoo.com/b?P=7658034e-34c8-11e1-add3-fbca62106ee5&T=1d95d32fl%2fX%3d1325457138%2fE%3d1705006764%2fR%3dgroups%2fK%3d5%2fV%3d2.1%2fW%3dH%2fY%3dYAHOO%2fF%3d2902214113%2fH%3dY29udGVudD0iR287UG9kY2FzdHM7V2Vic2l0ZV9TZXJ2aWNlcztXaWRnZXRzO1lhaG9vX1NlYXJjaF9NYXJrZXRpbmc7RmxpY2tyO0JyaWVmY2FzZTtGaW5hbmNlO0Jvb2ttYXJrO01vYmlsZTsiIGRpc2FibGVzaHVmZmxpbmc9IjEiIHNlcnZlSWQ9Ijc2NTgwMzRlLTM0YzgtMTFlMS1hZGQzLWZiY2E2MjEwNmVlNSIgc2l0ZUlkPSI0NDUyNTUxIiB0U3RtcD0iMTMyNTQ1NzEzODE0MTIyOSIg%2fQ%3d-1%2fS%3d1%2fJ%3d29228962&U=13cu89oiv%2fN%3dQZu.T0PDhC4-%2fC%3d493064.14543979.14562481.13298430%2fD%3dMKP1%2fB%3d6060255%2fV%3d1">
Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use
.
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar