Here are some great resources:
http://www.ozgrid.com/Excel/DynamicRanges.htm
http://www.andypope.info/charts.htm
http://peltiertech.com/Excel/Charts/ComboCharts.html
http://www.cpearson.com/excel/topic.aspx
http://www.contextures.com/tiptech.html
http://www.datapigtechnologies.com/ExcelMain.htm
http://www.anthony-vba.kefra.com/vba...ur_First_Macro
http://www.mvps.org/dmcritchie/excel/colors.htm

I think books are great for beginner types and people learning
intermediate-level Excel stuff. For really advanced stuff, Ive found no
better resource than this discussion group. This resource is really a
€˜collective intelligence of the best and brightest Excel users on the
planet. I still learn new Excel-related things each and every day. However,
these days Im not learning as much Excel stuff as I was learning a few years
ago. Since the learning curve has flattened, I spend some of my spare time
sharing my knowledge with others at this discussion group, and I spend a
certain amount of time learning Access because inevitably you get to a point
where you need to do things that Excel literally cant do, but Access can do
quickly and easily.

In conclusion, dont give up when it gets difficult. It hasnt been so long
that I forgot what things were like when I was just beginning to learn all
this stuff. Sometimes it is hard to learn some of the advanced features of
Excel, but it is rewarding too! Personally, I just like to solve problems
and Excel is a great tool for problem solvers.

--
RyGuy


"PatK" wrote:

you know...(and this tells you how long I have been mucking with this), I
used to do just exactly that, and have since forgotten. This might help me
in my current problem in fact.

As Rick wrote, I am in the throws of a RANGE nightmare, just trying to
figure out what sheet the range refers to, reference the data in the
range....etc)....

But you know....I am going to try recording, just to see what happens!

Thanks, Patk

"J Smith 555" wrote:

Patk,

I too am still learning how to code VBA for Excel. The one great tip that I
like to give is:
"Record your way to success"

Go into Excel, turn on the Macro recorder and just type in whatever into
whatever cell / range of cells. Then open up the VBA and see what it
recorded. From there you can see what is used and how it used.

Once you see that Excel records:
Range("D6").Select
ActiveCell.FormulaR1C1 = "Test Line of code"

You can change it to:
Range("D6").FormulaR1C1 = "Test Line of Code"

This is how I've learned most of my code. That and reading a lot of forums
too .. I would recommend this one along with ozgrid.com (forgive me Microsoft)

"PatK" wrote:

Ok..maybe a bit of venting here, as you guys are the BEST. I guess this is
more aimed at our friends at MS: WHERE IN THE HECK TO YOU LEARN THIS STUFF!

By this I mean, without these newsgroups, how could anyone very do learning
by research? Example:

I see a bit of code like:
FinalValue=WSM.Range("A65535").End(xlUp).Row

Now most of you great folks out there, I am sure, know EXACTLY what
".End(xlUp).row does, but how does a noob reseach and learn such a thing. It
is definitely not in the help, unless you know what it can be attached to
(like a range method or whatever), but even then, the help assume you know
too much already.

Help me out: where is a great book that breaks these things down so I can
know what is "possible" (not just what you all show me...and for which I
still often do not comprehend). I hate doing "what I see." I would rather
see an example, learn how it works, and then, maybe, stores some bits of
understanding my brain, for future reference.

Suggestions?

(ok..end of rant). As always, I could not survive without you all. This
newsgroup is the best "reference site" to help with excel, or any MS VBA app,
but should it be?

thanks, all,
Patk