Since I do not have often the occasion to solve others problems,
because I too am learning  from scratch, I will recommend this book to
you, that was recommended to me from this group some time ago.
Excel 2002 Power Programming with VBA, by John Walkenbach. that comes
with a CD with examples.
(Google the author's name, he has written lots of other books)
And it's true that if you search through the posts of this group,
you'll find some answers.

This book helped me a lot to start  with!

And as for Google, this book might also help  you to find the right
words to search for.
Because when one starts from scratch, one does not even know what to
type in Google's search line.

And try to read as many posts from this group as possible: when
you'll understand what there talking about, you'll know you have
progressed a lot :-)

And talking of Google, type Visual basic Excel and search in groups.
You might find a few where members will answer more basic questions
then this one.
They have helped me a lot when I just came, but now, it seems that
they are looking for bigger challenges then what we beginners can ask
for.

I spend many hours a day, and done subs that work  pretty well, but
that are certainly not very "elegant" from a real programmer point of
view.
Once I master what's in that book, I guess I'll try to find another
one, because the examples are sometimes too elementary.
Recording macros and looking at the code also helps to start with.
But there are things the recorder simply never makes.