![]() |
#1
|
|||
|
|||
![]() I am very new to excel and vba code and forums. I will try to explain my issue to the best of my knowledge. I will make mistake and my not give the proper grammar so if you would be kind. Thank you. Here is my issue. I am making a comparison with dates that I have on my spreadsheet and from the website. I wrote this code: If dos >= sDate And dos <= Term _ Or dos >= sDate And Term = #1/1/1900# Then [f1].Offset(i - 1, 0) = "covered" else [f1].Offset(i - 1, 0) = " not covered" It works fine until the website returns a blank cell. I then get an error message "type mismatch" I undertand it is because the cell is blank. I though putting #1/1/1900# would fix this but it doesn't. I also noticed in my local window the value for Term looks like this " ". Can this be fixed? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trouble with me animations | Halesowenmum | PowerPoint | 5 | 11-21-2017 04:14 AM |
![]() |
DanielMcCrea | Word | 1 | 09-27-2017 02:35 PM |
![]() |
welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
![]() |
Snaybot | Excel Programming | 1 | 05-15-2016 08:33 PM |
I'm having trouble doing these tasks | jackmackfack | Word | 4 | 02-19-2015 06:46 PM |