I have a table which is updated, then the values from three columns
transferred over to another sheet, folllowing on from the last time data was
transferred (the table gets wiped each time this is done.. The first two
columns are ok to find the last cell, as they are text, and are copied like
this:

Range("A2", Range("B65536").End(xlUp)).Name = "draughtsmenproject"
Range("draughtsmenproject").Copy
Sheets("Tally").Select
NextRow = Range("A65536").End(xlUp).Row + 1
Range("A" & NextRow).Select
ActiveSheet.Paste

The final column though, contains a SUM formula, which counts as a 'filled'
cell when excel checks. Can i get Excel to ignore the formula if the result
is 0, or would i be better using an offset function in VBA, to count across
the number of columns from one of the last two text entries to the last SUM
entry (which would be on the same line).

Any help is appreciated.

Richard
--
Richard