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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting worksheet name equal to variable value
Are you trying to select that entered worksheet if so try
worksheets(format(TodaysDate, "dd-mm-yy")).select you say that the names of the worksheets are already the dates so worksheets(format(TodaysDate, "dd-mm-yy")).name = format(TodaysDate, "dd-mm-yy") will just set the name the same. Please explain for if you need further help. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "newguy" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting worksheet name equal to variable value
That worked Thank You
Martin Fishlock wrote: Are you trying to select that entered worksheet if so try worksheets(format(TodaysDate, "dd-mm-yy")).select you say that the names of the worksheets are already the dates so worksheets(format(TodaysDate, "dd-mm-yy")).name = format(TodaysDate, "dd-mm-yy") will just set the name the same. Please explain for if you need further help. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "newguy" wrote: 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 |
Reply |
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 |