DateSerial

[mattDrum]

Hallo!

I use DateSerial like this "DateSerial(2014, 4, 1)" in vba.
I wonder if I can do this "DateSerial(201*, 4, 1)" the text in vba gets red like something is wrong, but it still works.
Is there another way to do this? I dont want to chance the code every year!

Thanks!

/Matt

 

[MickG]

Try:-

 DateSerial(Year(Now), 4, 1)

 

[Norie]

Matt

If the code goes red it means there's a syntax error and the code won't compile or run.

So I'm not sure what you mean when you say DateSerial(201*, 4, 1) works.

What are you trying to do anyway?

 

[mattDrum]

I cant explain the code goes red but it works. I dont know why or how but i does.
I have an excel workbook for every year, if I use "DateSerial(2014, 4, 1)" then i have to change it to "DateSerial(2015, 4, 1)" next year!
I dont want that, that why i wonder if i can do this instead "DateSerial(201*, 4, 1)" or if there is a better way.
/Matt

 

[mattDrum]

MickG I will test your code.

Thanks Matt