Hello!
i have three questions...

1st.
I want to make a function, that would create (write and edit) a empty schedule for the week and then my program would fill it afterwards, but before i start to write this long code i was wondering, if it is possible to just select the already made table in excel and open up the code for it ? Like in web programing where you can select the content and then press F11 and you get the code of the selection?

2nd.
i have to work with dates in this selection, right now the code works in strings so someone pastes the empty table and edites the dates and then the program crossreferences the cells that includes cells if they are the same or not. I would like to write code that would make these cells themselves but i have no idea how to get the number from the string i know in other languages you have to make an algorithem that seperates the string char by char and convert but i was wondering if there is an easier way in vba ?

3th.
is there a way to write a global variable in vba or not ? So that if i write a function i can still acess the variable even tho i used it in main code (i need this without sending the variable in function, so that if annything happens to the variable when function is active the main program then has the same data).