View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Incrementing a variable by 1

Hi Sskulkrinbait,

The normal method would be that shown by you:

iVar = iVar + 1



---
Regards,
Norman

wrote in message
oups.com...
Apologies for the simple question, but I can't find the answer by
searching the net.

In PHP you can increment a variable by 1 thus:

$var++;

In some forms of BASIC it's:

var +=1

How do you incremenet a variable by 1 in VBA other than:

iVar = iVar + 1

Is there simpler way?

Thanks.