referencing to an object in another subroutine

i am sorry, but i didnt fully get what you were saying. I am starting to learn the technical names so please do excuse my questions:

so i declared the variable as:
Private monthdatadate As Range
monthdatadate = Sheets("report").Range(Cells(2, 1), Cells(2, 4 + 2))

then when i tested a sub it says invalid outside procedure

oh i get it,

thanks a lot Joseph!

the test sub runs only wen the original sub has already been run. so i must create a new sub only for declarations. then ensure that it is run whenever i open the excel file so that any sub can be run without the need to run the original sub. i tried to save the declarations sub in Private Sub Workbook_Open(). but it wont work, do you have any solution?

ok! 'public' has to be used since it goes outside the module, i get it now! phew!

thanks a lot!!