VBA summing function

[Jase]

Hi, I am trying to sum a dynamic range with some code but if that range has
"value in it the sum function does not work. I want to exit the function if
if it is unable to sum. Any ideas? heres the code I am using:

Sheets("data").Range("B446").Value =
Application.WorksheetFunction.Sum(Worksheets("data").Range("B" &
Sheets("graphs").Range("D267").Value _
& ":B" & Sheets("graphs").Range("D268").Value))

thanks,

Jase

 

[Singapore Computer Service]

Hello,

This is a FrontPage group. You may want to ask in the Excel Programming
group instead
http://www.microsoft.com/communitie...x?dg=microsoft.public.excel.programming&exp=1

Regards,
Singapore Computer Home Repair Service
http://www.bootstrike.com/ComputerService/
Video Conversion VHS Video8 Hi8 Digital8 MiniDv MicroMv
http://www.bootstrike.com/VHSVideoConvert/