Add the last year to my loop

**SIMBAtheCAT** · 07-10-2014, 10:02 AM

Good morning,

I'm trying to find a way so that when new data is available for 2015, I won't have the rewrite the code. Is there a way to do something like :

If rg.value= "abc"& Actual year Then

Please Login or Register  to view this content.

Thank you

**Norie** · 07-10-2014, 10:04 AM

You can use Year(Date) to get the current year.

**Norie** · 07-10-2014, 10:12 AM

Accidental dupe.

**JOHN H. DAVIS** · 07-10-2014, 10:13 AM

Maybe:

Please Login or Register  to view this content.

**SIMBAtheCAT** · 07-10-2014, 10:37 AM

"" & Year(Date) is perfect!

Thank you.

Add the last year to my loop

LinkBack

Thread Tools

Rate This Thread

Display

Add the last year to my loop

Re: Add the last year to my loop

Re: Add the last year to my loop

Re: Add the last year to my loop

Re: Add the last year to my loop

Thread Information

Users Browsing this Thread

Similar Threads

Keep month and date but change year to current year and reoccur when new year rolls over.

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

Convert a multiple year list of 365 days/year into an equivalent of 360 days/year

picking up fiscal year in a for loop, vba. Excel

Loop using Month() and Year()

Bookmarks

Bookmarks

Posting Permissions