I have a spread sheet that I set up to output dates and time. I want to save these dates and times into an array. So that I can look at another sheet and view all the dates and time enter outputed in the first sheet. I also would need the ability to move dates and times in and out of the sheet also.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Saving into array
- Thread starter MRice
- Start date
Damon Ostrander
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 4,239
Hi Marcus,
It is quite easy to store the contents of a range of cells in an array in VBA. But beyond this I am not clear about what it is that you want. Can you be more specific about what you mean by viewing the dates and times in another sheet? How is this different from just copying, or even linking, the dates and times from the first sheet to the second? And when you refer to moving the dates and times in and out of the sheet, how do you plan to inform your code which dates and times to move in or out, and where to place them?
Damon
It is quite easy to store the contents of a range of cells in an array in VBA. But beyond this I am not clear about what it is that you want. Can you be more specific about what you mean by viewing the dates and times in another sheet? How is this different from just copying, or even linking, the dates and times from the first sheet to the second? And when you refer to moving the dates and times in and out of the sheet, how do you plan to inform your code which dates and times to move in or out, and where to place them?
Damon
Upvote
0
Similar threads
- Question
- Question
