The Empty Keyword only applies to variables:[VBA]Dim X
'X is now Empty
X = 2
'X is no longer Empty
Range("A1") = Empty ' Invalid use of Empty[/VBA]
Instead use: [VBA].Value <>""[/VBA]
The Empty Keyword only applies to variables:[VBA]Dim X
'X is now Empty
X = 2
'X is no longer Empty
Range("A1") = Empty ' Invalid use of Empty[/VBA]
Instead use: [VBA].Value <>""[/VBA]
Please take the time to read the Forum FAQ
Posting Permissions
Reply With Quote