|Subject:||use VB code IF to automate filling in 11 columns|
|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.