I am trying to debug an existing Excel program that is not pulling data from
one specific column in multiple worksheets. All other columns are numeric
data and populate correctly when the VB macro in run.

The cell formula below converts a numeric indicator from a separate
worksheet, to either the alpha character 'C' or leaves the cell blank.

=IF(VLOOKUP(A11,Usage,'Inputs-Usage'!$FF$6,FALSE)<1,"C","")

The VB code in the macro module that provides the cell data to a .cvs file
is as follows;

''==== Per Steve, this should not be changed to Zero but should be null, or
real value, 09/13/2006
If IsError(Item.Range("Q" & intCounter).Address) = True Then
newVal = ""
Else
newVal = Item.Range("Q" & intCounter).Value
End If

Column 'Q' is the source for the alpha character to the .cvs file from which
the final report data is pulled.

The variable 'intCounter is as follows;

For intCounter = 9 To intNumberOfDayRows + 8

Can someone provide a possible solution to this problem.

Thank you
--
TWN