Look up VBA documentation using Excel Help
 

I'm not faimilar with (or don't quite understand) how to
use online Object Browser which is invoked by pressing
the F2 key. Can someone please explain how to look for
documentation ?

For example. I want to learn how to use the "cells.find
(...)" I need to find out what description of each
arguments and what it returns when the command is
complete.

Can someone please guide me to look up this info or
direct me to a website to read up on how to use the
object browser ?

Thanks in advance.

Look up VBA documentation using Excel Help
 

Wellie,

The problem with the object browser is that you have to have a fair
understanding of the object model to use it effectively.

For instance, Cells is a range, so you have to look up Range in the OB not
Cells( obvious eh?<g), and look for the Find property within the Range
object. This will then give you a description of the Find method.

VBA Help is a better tool for this, you can loo Find and Cells within there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Wellie" wrote in message
...
I'm not faimilar with (or don't quite understand) how to
use online Object Browser which is invoked by pressing
the F2 key. Can someone please explain how to look for
documentation ?

For example. I want to learn how to use the "cells.find
(...)" I need to find out what description of each
arguments and what it returns when the command is
complete.

Can someone please guide me to look up this info or
direct me to a website to read up on how to use the
object browser ?

Thanks in advance.

Look up VBA documentation using Excel Help
 

In the codepane click the mouse on the word ".Find"

Then press the F1 key. The context sensitive help usually works fairly well.

Troy

"Wellie" wrote in message
...
I'm not faimilar with (or don't quite understand) how to
use online Object Browser which is invoked by pressing
the F2 key. Can someone please explain how to look for
documentation ?

For example. I want to learn how to use the "cells.find
(...)" I need to find out what description of each
arguments and what it returns when the command is
complete.

Can someone please guide me to look up this info or
direct me to a website to read up on how to use the
object browser ?

Thanks in advance.