Missing before statement

ساخت وبلاگ

آخرین مطالب

امکانات وب

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;
}
}
}
CodingForums...
ما را در سایت CodingForums دنبال می کنید

برچسب : نویسنده : codingforums بازدید : 160 تاريخ : شنبه 1 ارديبهشت 1397 ساعت: 18:29

آرشیو مطالب

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

لینک دوستان

خبرنامه