August 18th, 2003, 11:21 AM
|
 |
Inherits Programmer.Slacker
|
|
Join Date: Aug 2003
Location: Between my Id and your Ego
|
|
VB 6 - Excel Question
Hey guys - I gotta question for you. I'm importing data into a worksheet in Excel from SQLServer, and am calculating population averages and sums on some of the rows. I'm having a problem with the calculation of one value though. I'm trying to extract the sum of two values in a row, which have been calculated as sums of two values from their corresponding columns. The only problem is that those values ignore certain other fields in those columns, so Excel gives an error on the cells of "Formula omits adjacent cells", and the "grand total" field won't calculate due to the error. Does anyone know how to ignore errors in a field during design time?
__________________
Fisherman
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
