> "your reference to worksheets at the top of the module".
No, I think I said at the top of the METHODS.
Dim AddressSheet as Worksheet
Set AddressSheet = Sheets ("Addresses")
...
Call AddressSheet.Range("A1:B10").Clear
Regards, Dave S
----- Original Message -----
From: "Torstein Johnsen" <sejohnse@yahoo.no>
To: <ExcelVBA@yahoogroups.com>
Sent: Monday, January 02, 2012 7:02 PM
Subject: Re: [ExcelVBA] Re: Help! There is an evil genie in my VBA
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
----------------------------------Yahoo! Groups Links
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1416 / Virus Database: 2109/4117 - Release Date: 01/01/12
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