Unanswered: Excel 2000 to Excel XP - i need help!!
i am currently workin on a project at college for my a levels. at my college we have computers that run windows 98 and excel 2000. when i bring my work home to my pc, i have windows xp and excel xp, and much of the code isnt workin. is there a reason for this? i am really stuck, and i am currently stuck in an office attempting to get it to work. help!!!!
this is the part of code that isnt working
ActiveSheet.Unprotect 'Unprotect the main sheet
[B2] = [B2] + 1 'Add 1 to the cell B2
QuotationNumber = [B2] 'The cell named quotation number is equal to the cell B4
any part of my vb project that contains square brackets doesnt work, what can i do? even the simple input boxes dont work
[B7] = InputBox("Enter Customers Name")
[C7] = InputBox("Enter Customers Address")
[D7] = InputBox("Enter Customers Postcode")
[F7] = InputBox("Enter Customers Home Number")
[G7] = InputBox(" Enter Customers Mobile Number")
the errors are appearing where the square brakcets are....is there anybody out there who can help me?