Why a this variable declared as a Range is declared equal to null?

Asked Nov 25 '19 at 05:12

Active Nov 25 '19 at 05:30

Viewed 29 times

Hi everyone I'm just curious about why this code works and the next one doesn't here it goes:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim cell As String
cell = Sheets("IntQ").Range("A5").Value
 If cell = "" Then
  cell = "This should work"
  Sheets("IntQ").Range("A5").Value = cell
 End If
End Sub

Here goes the code that doesn't work:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim cell As Range
cell = Sheets("IntQ").Range("A5")
 If cell.Value = "" Then
  cell.Value = "Elige la marca del producto"
 End If
End Sub

The prompt says that the cell variable value is null

edited Nov 25 '19 at 05:30

41686d6564 stands w. Palestine

19,168
12
41
79

asked Nov 25 '19 at 05:12

Rodrigo Reyes

I'm trying that the cell A5 shows a value when it is empty – Rodrigo Reyes Nov 25 '19 at 05:14
1

Are you using `Option explicit`? Try it like this instead: `Set cell = Sheets("IntQ").Range("A5")` – braX Nov 25 '19 at 05:15
Does this answer your question? [What is the difference between dim and set in vba](https://stackoverflow.com/questions/3872339/what-is-the-difference-between-dim-and-set-in-vba) – 41686d6564 stands w. Palestine Nov 25 '19 at 05:30
And keep in mind that an empty string is not the same thing as `null`. – braX Nov 25 '19 at 05:43

Why a this variable declared as a Range is declared equal to null?

0 Answers0