Setting worksheet name equal to variable value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newguy - 13 Dec 2006 01:24 GMT

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 to this Message

Martin Fishlock - 13 Dec 2006 04:43 GMT

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.

Signature

Hope this helps
Martin Fishlock
Please do not forget to rate this reply.

> 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
[quoted text clipped - 13 lines]
>
> Any Help would be greatly appreaciated

Reply to this Message

newguy - 13 Dec 2006 23:09 GMT

That worked Thank You

> Are you trying to select that entered worksheet if so try
>
[quoted text clipped - 30 lines]
> >
> > Any Help would be greatly appreaciated

Reply to this Message