I keep getting the above message everytime I try run a piece code.

the code I am running is the following:

Dim cell As Object
Dim strPath As String
Dim strMonth As String
Dim strYear As String

strPath = Sheets("admin").Range("b4").Value & "\01. Data\"

For Each cell In Range("periodtosearch")

strMonth = Left(cell, Len(cell) - 5)
strYear = Right(cell, 4)
Sheets("admin").Range("b10").Value = strMonth
If strMonth.Value = "January" Or strMonth.Value = "February" Or _
strMonth = "March" Then strYear.Value = strYear.Value + 1


it breaks on the if statement and highlights the strMonth the word? An
ideas

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=53918

Hello
The Value property is not available with a string variable.
So you should simply amend your code with
If strMonth = "January" Or strMonth = "February" Or _
strMonth = "March"

HTH
Cordially
Pascal

"funkymonkUK" a
écrit dans le message de news:
...

I keep getting the above message everytime I try run a piece code.

the code I am running is the following:

Dim cell As Object
Dim strPath As String
Dim strMonth As String
Dim strYear As String

strPath = Sheets("admin").Range("b4").Value & "\01. Data\"

For Each cell In Range("periodtosearch")

strMonth = Left(cell, Len(cell) - 5)
strYear = Right(cell, 4)
Sheets("admin").Range("b10").Value = strMonth
If strMonth.Value = "January" Or strMonth.Value = "February" Or _
strMonth = "March" Then strYear.Value = strYear.Value + 1


it breaks on the if statement and highlights the strMonth the word? Any
ideas?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=539184

thanks that was such a stupid mistake.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=539184