Macro not copying the values retrieved in the variable in code

Perhaps

Please Login or Register  to view this content.

No these did not help , the exact query is:
.Cells(iRow, iColumn + 29).Value = rsData!Variable_Six

where rsData is the recordset
and .Cells(iRow, iColumn + 29) is the location in excel where it is trying to write

Nobody can read your brain.

What do you expect us from such a little information?

Last guess

Google "CopyFromRecordset"

ok I will try that - Well this equation runs inside a loop where the column number is increased by 1 every time.
For each column it is working fine except I think the situation arises in copying in the last 2 columns- but even then the watch and immediate windows showed correct value. The issue was only when 0 value got pasted into intended excel cell.