Problem with IF...THEN condttion in VBA

[UpnDown]

I have cell A6 with a formula that produces a text message with a record number when there exists a content match of a SS # in cell B10 within a defined range of cells: =IF(MATCH($B$10,Curr_Cycle_SS_Nos,0)>0,"SS # matches record "&MATCH($B$10,Curr_Cycle_SS_Nos,0)&" in batch.","") The formula works fine but I cannot seem to create an IF...THEN statement in my macro that will match the TRUE state of the condition. I'm doing this to produce a message box with instructions in that situation. E.g. I have tried using If (Len("A6") > 0) Then... Even though that expression will evaluate properly in a cell on the spreadsheet (without the " marks) it will not work in my macro. I've tried many different tests besides the LEN function with different syntax but I'm lost.

 

[UpnDown]

I have cell A6 with a formula that produces a text message with a record number when there exists a content match of a SS # in cell B10 within a defined range of cells: =IF(MATCH($B$10,Curr_Cycle_SS_Nos,0)>0,"SS # matches record "&MATCH($B$10,Curr_Cycle_SS_Nos,0)&" in batch.","") The formula works fine but I cannot seem to create an IF...THEN statement in my macro that will match the TRUE state of the condition. I'm doing this to produce a message box with instructions in that situation. E.g. I have tried using If (Len("A6") > 0) Then... Even though that expression will evaluate properly in a cell on the spreadsheet (without the " marks) it will not work in my macro. I've tried many different tests besides the LEN function with different syntax but I'm lost.

<code>Found it, thanks. I should have used Len(Range("A6").Value2)</code>