thx for replying..

Problems faced:

1) the given code is a function .. while the command button is a sub
function . I do not know how to convert into a sub function

2)Alternatively , if i need to create a sub function, how to write the
code for a summation problem:


Sum = Sum + Cells(6 + j, 4) * Cos(n * ang).

Cells(6 + j, 4) cannot be used in a subfunction.. so how should i
convert it from a function code to a sub function click().


PLs help.. thx


---
Message posted from http://www.ExcelForum.com/