Missing before statement

HELP!!! I am a VBA person and tried to change one of my codes to JavaScript, but I keep getting a "Missing before statement" error. It is driving me crazy. Can someone please help me out and tell me what I am doing wrong? Thank you in advance for any help you can give me!!

Code:

function COMPLETE (){

var p, endrow, Services,  COMPLETE, oLastRow;

Set Services = ActiveWorkbook.Sheets("Services");

Set return ActiveWorkbook.Sheets("Complete");

endrow = Services.Range("A" + Services.Rows.Count).End(xlUp).Row;

for(p=endrow; p<=2; p++){

if(Services.Cells(p, "P").Value == "99" ){

Set oLastRow = Worksheets("Complete").ListObjects("Complete").ListRows.Add;

Services.Cells(p, "P").EntireRow.Copy;

oLastRow.Range.PasteSpecial xlPasteValues;

Services.Cells(p, "P").EntireRow.Delete;

}

}

}

برچسب: نویسنده: آیلین رضوانی تاريخ: شنبه 1 ارديبهشت 1397 ساعت: 18:29

درباره سایت

آخرین مطالب

امکانات وب

Missing before statement

صفحه بندی

آرشیو مطالب

پيوندهای روزانه

لینک دوستان

خبرنامه