neerajarora8077
New member
hi guys,
I have a workbook of students result in which "MANUAL PRINT RESULT" worksheet have a data validation list in cell Z2.
And I have made a macro to print entire list of data validation list in cell Z2 which is named as "printpdfdvlisteach".
My problem is that I could not make a macro to print desired choice as 5 to 8, or 7 to 36 etc. when typed the choice in cells AC3 and AD3 where AC3 asks for the starting range and AD3 for ending range of the data validation list of cell Z2.
pls provide the macro for this problem as I don't know enough about excel vba programming.
this helps for students of the govt. school and all students will be thankful to you.
thanks
neeraj arora
I have a workbook of students result in which "MANUAL PRINT RESULT" worksheet have a data validation list in cell Z2.
And I have made a macro to print entire list of data validation list in cell Z2 which is named as "printpdfdvlisteach".
My problem is that I could not make a macro to print desired choice as 5 to 8, or 7 to 36 etc. when typed the choice in cells AC3 and AD3 where AC3 asks for the starting range and AD3 for ending range of the data validation list of cell Z2.
pls provide the macro for this problem as I don't know enough about excel vba programming.
this helps for students of the govt. school and all students will be thankful to you.
thanks
neeraj arora