Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting worksheet name equal to variable value
I have several worksheets in my workbook and need to input information
into a worksheet based on the date entered by the user. the worksheets are name 01-Dec-06 up too 31-Dec-06 in order. The user in most cases will enter the information in order meaning after they enter the information on the 1st they will then input the information on the 2nd. But they could possibly do them out of order if they wanted. That is why I am trying to select the worksheet based on the date entered since the worksheet names and the date entered are formated the same. Here is my process so far for doing this. I have a Variable newwrksheet and a Variable of type string called TodaysDate I have tried worksheets(newwrksheets).name = TodaysDate and it gives me an error because the types are a mismatch. Any Help would be greatly appreaciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with setting the worksheet variable ws | Excel Discussion (Misc queries) | |||
Setting varible to equal values of a # of cells | Excel Programming | |||
Setting a cell equal to another worksheet cell fails (sometimes) | Excel Worksheet Functions | |||
Setting zoom of 2 sheets equal | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming |