#1
|
|||
|
|||
trouble with code
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? |
#2
|
|||
|
|||
You need to deal with Term prior to getting to this point in your code.
This should give an idea... Code:
Sub Testing() Dim Term As Variant 'don't know how your variable is being assigned so... Term = " " 'check if its a date If Not IsDate(Term) Then 'assign a date Term = DateSerial(1900, 1, 1) End If 'message box to show what Term currently is MsgBox Term End Sub |
#3
|
|||
|
|||
trouble with code
My "Term" is dim as string so I can pull it from the website and are you saying I should use your if statement to check if it is a date and if not then make return a date like 1/1/1900?
|
#4
|
|||
|
|||
trouble with code
Quote:
I ran your code and it answered my question. Thank you so much. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trouble with me animations | Halesowenmum | PowerPoint | 5 | 11-21-2017 04:14 AM |
Trouble with Hyperlinks | DanielMcCrea | Word | 1 | 09-27-2017 02:35 PM |
VBA Code to search for field codes with certain text before the Field code and to change style | welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
Parsing Code Macro Trouble! | 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 |