Use of Selection.Find & ActiveCell
Don't feel so bad. That is what we are all here for, to help each other
learn and grow. When I first started out working in VBA, I initially used
the macro recorder in Excel to help me learn the code. Took me a while to
learn VBA (about 3 months), but I did eventually get it. However, since I
tended to be one of those users that wanted to do other things on the same
system while that particular instance of Excel was running code, I had to
learn VBA rather fast cause all of the Active/Select Objects/Methods were
creating issues for me otherwise that I didn't like.
A few of the other things that I use a lot within VBA are the
Intermediate/Watch Windows, Object Browser, Help files, and the various
other debugging tools (a few of which, I created my own methodology). It
took me some time to learn the best way to use these tools, but once I
gotten the hang of each of them with regards to how they work and what
information they provide, it made my tasks easier.
Most of my time here lately has been dealing with working in Access VBA as
I'm in the midst of creating a DB program.
--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Steve Slechta" wrote in message
...
-----Original Message-----
This looks like beginners coding, so I will go through a
few things that may help you out.
Ron,
You're correct. I am a beginner. The world of objects has
not come into focus for me yet. I'm at the same stage in a
C++ class I'm taking as well. I'm keeping the notes you
provided here so when objects start to make more sense, I
can implement this code. I may play with this code anyway
for the learning process.
I feel bad for posting this then figuring out that it was a
dumb mistake right after posting...... story of my life. ;)
Thanks for the help!
Steve Slechta
|