Quote Originally Posted by sheeeng
Hi all.
Very simple questions here. Hope all can post their experience!

Anyone know how to pass parameter of any objects (pls list all you know)?
eg. pass Range to a sub.

What is difference btw ByVal and ByRef?

What is the formal naming convention for VBA (all objects)?

Thanks.
There are many questions here. Most are the kind of questions that are best (initially) sought from VBA's help system or from a search of the KB area of this forum.