If Not IsEmpty() Not Working Properly

[jjcgirl]

I am attempting to add a series to a chart if a cell (B4) has data in it using the following code. When I step through the statement it Jumps from "If Not IsEmpty(B4) Then" to "End If" even though there is data in cell B4... I don't know why this isn't working and any help would be much appreciated! Thanks!

If Not IsEmpty(B4) Then
ActiveSheet.ChartObjects("Chart 2").Activate
With ActiveChart.SeriesCollection.NewSeries
.Name = "='Summary'!$C$4"
.Values = "='Peer Analysis.xlsm'!CTwo_Stat1"
.XValues = "='Peer Analysis.xlsm'!Chart_Dates"
End With
End If

[AB33]

Please Login or Register  to view this content.

[jjcgirl]

I knew it was probably something small like that, that I was missing! Thanks for the help!