Hi,

I am trying to find a way where I can use a worksheet cell value in vba code. ie.. I have vba code 
Sheets("School Term").Range(B4:B201, B436:B572").Copy
Sometimes these values will change and I would like to just change them in a cell in a worksheet and have the code updated from the cell values. is this possible please.

Regards
David