Posted by Michael on December 27, 2001 12:35 PM
OK, This is probably rather simple, but I can't figure it out.
I need to define a variable as follows:
variable name = "GA" & Worksheet("Data Sheet").Cells(2,4).Number & Right(Worksheet("Data Sheet").Cells(3,4).Value,2)
Where the variable name is just that, the Cells call out is as follows(2,4) is a drop down list box containing the Months of the year (In Order) so that the number call out will return the numeric monthe (ie November = 11) and Cells (3,4) is a drop down box listing years (ie 2001, 2002, 2003, ...2030) so that the right function will give me the last two digits of the year. The end result should be GA1101, etc. The problem is that it doesn't work at all. I need this rather badly. Can Anybody Help Me Please.