Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 39
  • Last Modified:

Sign ' := ' in vba

What is the ' :=' sign in excel Vba ? Is it some sort of operator ?
0
Shrikant Dixit
Asked:
Shrikant Dixit
  • 2
  • 2
2 Solutions
 
Wayne Taylor (webtubbs)Commented:
It's used to specify the values for the arguments in a function. It has no other direct meaning.

An example (copying worksheets) on it's use is....

    Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

...which creates a copy of Sheet1 and places it after Sheet3. It can also be written like this...

    Worksheets("Sheet1").Copy , Worksheets("Sheet3")

Note the comma. When not specifying the argument as in the first example, arguments must be in the function order, which for the Worksheet.Copy function is ([Before], [After]).
0
 
Shrikant DixitAuthor Commented:
Dear Mr.Taylor,
Thank a lot. I wonder why nothing is said about this in msdn or any other litrature.
Thanks again.
Shrikant Dixit
0
 
Shrikant DixitAuthor Commented:
Dear Mr. Taylor,
Thanks a lot. Now I am fully satisfied. My question is resolved.
Shrikant Dixit
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now