Recent content by cyrus1979

Hi,GERRY I just wondering which I can choose between function and subs. However, I use Function to attempt what I want to do. I am not that good in using VBA. I am wondering how I can compose the code that can be automatically executed, at the same time, the data in $AA$11:$AA$207 would be...

HI,RGDS,GEOFF I put this on my code view window which is from Sheet5, not from the module. -------------------- Function Update() my code End Function Sub Run_Update() Update End Sub ----------------- when I do this,the compiler said "compiler error, no =" and high light the "Update" in...

Hi,RGDS,GEOFF It is not working. I have tried to use "Private Sub Worksheet_Change(ByVal Target As Range)", when I type"=worksheet_change($AA$11:$AA$207)",it is running again and again. I can just use "esc" to stop it .In this case, I can not run the software Evolver properly, it prompt"running...

Hi,RGDS,GEOFF Do I need to type"=Run_Update()" in any of the cell in the relevant spreadsheet? Many thanks Cyrus

HI, I got a problem on the invoking of macro. What I have done is just design a function which is shown in the following: ----------------------------------------------------------- Function update() Dim I As Integer Dim Lorry_number As Integer Dim J As Integer Dim K As Integer Dim...