ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   empty (https://www.excelbanter.com/excel-programming/402204-empty.html)

treasuresflemar

empty
 
Dim tday as varant

Why would this line return an error 424 object required?

If tday is empty then



John Bundy

empty
 
If that is copy and pasted it is a spelling error Variant
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"treasuresflemar" wrote:

Dim tday as varant

Why would this line return an error 424 object required?

If tday is empty then




treasuresflemar

empty
 
Was not cut and pasted. Spelling is right in code

"John Bundy" (remove) wrote in message
...
If that is copy and pasted it is a spelling error Variant
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"treasuresflemar" wrote:

Dim tday as varant

Why would this line return an error 424 object required?

If tday is empty then






Bob Phillips

empty
 
If IsEmpty(tday) Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"treasuresflemar" wrote in message
...
Was not cut and pasted. Spelling is right in code

"John Bundy" (remove) wrote in message
...
If that is copy and pasted it is a spelling error Variant
--
-John
Please rate when your question is answered to help us and others know
what
is helpful.


"treasuresflemar" wrote:

Dim tday as varant

Why would this line return an error 424 object required?

If tday is empty then








treasuresflemar

empty
 
Thnak you that worked great
"Bob Phillips" wrote in message
...
If IsEmpty(tday) Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"treasuresflemar" wrote in message
...
Was not cut and pasted. Spelling is right in code

"John Bundy" (remove) wrote in message
...
If that is copy and pasted it is a spelling error Variant
--
-John
Please rate when your question is answered to help us and others know
what
is helpful.


"treasuresflemar" wrote:

Dim tday as varant

Why would this line return an error 424 object required?

If tday is empty then











All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com