Tony,

For many methods, named parameters are used, and the := is used to assign a value to the named
parameter. For example, you could use either of these with the find method:

Dim c As Range
Set c = Cells.Find(What:="myFindString", LookIn:=xlValues, lookAt:=xlWhole)
This example leaves out the After:= parameter (but doesn't require a space holder for it).

Set c = Cells.Find("myFindString", , , xlWhole)
This one leaves out the parameter names (and skips the After and LookIn parameters) but requires
space holders (the commas).

HTH,
Bernie
MS Excel MVP


"ajocius" wrote in message
...

Group,
I often see examples of VBA code using the := (colon equal). What
is this and what is it typically used for? It appears to be some form
of assignment.

Thank you in advance........

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=392118