use VB code IF to automate filling in 11 columns

Giganews Newsgroups
Subject: use VB code IF to automate filling in 11 columns
Posted by:  smart.daisy
Date: Mon, 29 May 2006

I used belowed VB code IF to automate fill in 11 columns:

If Cells(p, "D").Value >= DateValue("01/01/2005") Then
            a = Cells(p, "H").Value
            b = Cells(p, "A").Value
            ............

The first ten work pretty well, but the last one, 11 one fails. Is it the
reason that IF in VB only allows ten variance? Thanks.

Replies