Posts by abdiwahab

    Hi
    I am trying to save my workbook auto macro on my doc with date and name but am getting this error all the time and i am using window office 2003
    thanks


    am getting this error : compile error expected variable or procedure not module

    Re: macro time cell


    [QUOTE=abdiwahab;714034]hi all please i need help am running excel like duty signOn times i got about 50 cells, duty number and sign On times so i would like the cursor to jump to cell currant time when time changes please help thank you


    i tried to upload workbook no luck
    [TABLE="class: cms_table, width: 363"]

    [tr]


    [TD="class: cms_table_xl64, width: 46, bgcolor: transparent, align: center"]DUTY[/TD]
    [TD="class: cms_table_xl64, width: 437, bgcolor: transparent, align: center"]SIGN ON TIME[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]10[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]07:00[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]11[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]07:30[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]12[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]08:00[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]13[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]08:10[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]14[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]08:50[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]14[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]09:10[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]16[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]09:35[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]17[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]09:45[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]18[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]09:55[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]19[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]11:00[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]20[/TD]
    [TD="class: cms_table_xl66, bgcolor: transparent, align: center"]12:30[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]21[/TD]
    [TD="class: cms_table_xl66, bgcolor: transparent, align: center"]12:33[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]22[/TD]
    [TD="class: cms_table_xl66, bgcolor: transparent, align: center"]13:00[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]23[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]13:42[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]24[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]16:00[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]25[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]16:30[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]26[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]16:33[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]27[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]16:35[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]28[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]16:41[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]29[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]17:03[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]30[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]17:33[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]31[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]18:50[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]32[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]19:10[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]33[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]19:22[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]34[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]19:44[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]35[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]21:45[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]36[/TD]
    [TD="class: cms_table_xl65, bgcolor: transparent, align: center"]21:56[/TD]

    [/tr]


    [tr]


    [TD="class: cms_table_xl63, bgcolor: transparent, align: center"]37[/TD]
    [TD="class: cms_table_xl66, bgcolor: transparent, align: center"]22:10[/TD]

    [/tr]


    [/TABLE]

    hi allplease i need help am running excel like duty signOn times i got about 50 cells, duty number and sign On times so i would like the cursor to jump to cell to currant time when time changes please help thank you


    i tried to upload workbook no luck


    am looking like example say cell C data format by time like 07:00,09:00,11:00, 17:00 and so on , i would like when the time like now if its 20:30 and am on top call like 07:00 oclock , i want the cursor to jump the currant time thanks