Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello! I have become somewhat unsure of certian things regarding the syntax
in vba. therefor I would truly appreciate answers to the following questions: 1) In the beginning of a sub that takes two arguments do you have to write: Private Sub checkReturnDifference(ByVal rng1 As Range, ByVal rng3 As Range) or can you write ....(ByVal rng1, rng3 As Range) 2) When declaring new variables is it necessary to write: Dim i As Integer Dim k As Integer ..... or is there a shorter way of doing this? I know that these questions does not seem very important but when you have meny variables then it does actually make a difference. thus, any help appreciated! thank you all very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF, THEN SYNTAX | Excel Worksheet Functions | |||
Syntax help please | Excel Programming | |||
Syntax help! | Excel Programming | |||
If then syntax | Excel Worksheet Functions | |||
Help with VBA syntax | Excel Programming |