View Single Post
  #1   Report Post  
mango
 
Posts: n/a
Default method and function

dear all,
what is the difference between method and function?
1)method only used for object whereas function(be it vba or excel worksheet
function) can use generally? can give example?

2) sometimes quite confuse of the syntax. for example,
range.select
range is property but why also got parameter? after type range and press
spacebar or bracket, parameter will show.
range here is property or object?
select here is a method but parameter not support but worksheets.select
support parameter.
can someone tell me how to understand the syntax? what condition with
parameter and what condition without?

rgds and thanks