I am using Windows 7 64 bit and Excel 2010. My fiscal year starts September
1,2015 and ends August 31,2016. I have entered the date August 31, 2015
into cell T2. I put the date September 1, 2016 into cell T3. Here is the
part of my macro that I am having problems with:
> If (Now() > t2) And Now() < t3 Then
> Range("A59").End(xlUp).Select
> Selection.Offset(1, 0).Select
> Else
> Range("A113").End(xlUp).Select
> Selection.Offset(1, 0).Select
> End If
>
I would like to paste what I have copied to one part of the totals sheet
until the fiscal year changes and then paste the copied cells to another
place on the totals sheet. I am basically keeping up with two years of
totals for two fiscal years rather than creating a new spreadsheet every
year.
My problem is that my code always skips to the else part of the if
statement. Am I using the wrong dates or wrong VBA code or what?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
