Hi,
I currently have a workbook that can generate a new sheet via a macro button that is titled with the current date that the macro button was clicked. E.g "08-15-2019". I have it so that it will take you to the sheet named by the current date if it already exists and if it doesn't, it'll create one (named by the current date). I also have a user form that can be used to print information to the cells of the various sheets.
I want to be able to reference the sheets to print information on based on the current date that my excel user form is used on. However I do not wish to right 1000s of lines of code just to explicitly reference every possible date for the foreseeable future: e.g Range("08-15-2019!B4").Cells(1, 1) etc.
I tried to use: Range("Date$!B4").... but given that its within "" I knew it wouldn't work. Furthermore I tried Range(Date$!B4).... but that also doesn't work. How could I get my code to search through the workbook for the various sheets until it finds the one named with current date without explicitly referencing it? Or better yet how can I reference the sheet simply by having the program search for the one named by the current date?
Many Thanks!
Bookmarks