Conditional statement on two variables taking dates

Asked Oct 31 '14 at 06:41

Active Oct 31 '14 at 06:41

Viewed 44 times

I have a piece of code where a variable (Holdout_date) takes a date in a particular cell and then there is a block of code which is conditioned on the statement: if another variable (lastdte) takes a date equal to Holdout_date then activate sheet(3). However while running this code i am getting error 424(Object required). How do I get past this? Thanks in advance

Dim lastdte As Date
Dim Holdout_date As Date
Holdout_date = Range("A13")
Range("D1048576").End(xlUp).Select
lastrow = ActiveCell.Row
lastdte = Range("B" & lastrow)
If Not lastdte Is Holdout_date Then  
Sheet(3).Activate
End If

edited Jul 09 '18 at 19:34

Community

asked Oct 31 '14 at 06:41

Rajarshi Bhadra

1,826
6
25
41

1

First of all it will be: Sheets(3).activate. Second is convert lastdte and Holdout_date to long then compare it directly like 'if lastdte = Holdout_date then' – Jur Pertin Oct 31 '14 at 06:51
Thank you for the correction. It has worked! – Rajarshi Bhadra Oct 31 '14 at 06:54
Two important links for you. [THIS](http://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros/10718179#10718179) and [THIS](http://stackoverflow.com/questions/11169445/error-finding-last-used-cell-in-vba) – Siddharth Rout Oct 31 '14 at 07:56
Thank you. The links were very useful! – Rajarshi Bhadra Oct 31 '14 at 10:47

Conditional statement on two variables taking dates

0 Answers0