View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Organizing functions


Bob Phillips wrote:
How can you 'criticise' anyone for using comments<g


Sorry to shock you, Bob <vbg.

I agree everything you've said here about comments. It's just that Jim
said he comments *all* of his variables, so presumably we'd see either
something you (and me) would call 'useless' e.g.

' Declare an ADO Connection object
Dim adoConn As ADODB.Connection

or something I'd called a non-meaningful name e.g.

Dim var1 As String ' Connection string value
Dim var2 As ADODB.Connection ' ADO connection object

Jamie.

--