Simple VBA if

[sassriverrat]

Brainfarting because obviously this isn't right. Ears are open.

THanks

    If Worksheets("Developer").Range("I46").Value = "'Network" Then        dpathname = cpathname
    Else: dpathname = bpathname
    End If

 

[MARK858]

The debug piece of coding returned nothing

The debug.print piece of code cannot return nothing in your Immediate window if you have a sheet called Developer. Re-run and look again but if the message boxes "worked as intended" I don't see how you can have your previous statement "it's like it simply skipped over the whole dpathname."

 

[sassriverrat]

It did....but I'm not sure why. Something has been buggy lately. As seen in another post, I have a cell that was

 ='Network"

with "general" formatting and it was still showing an equal to zero (0)....

Then there was a case where the workbook, when opening another workbook, caused all of excel to freeze. But these have been one-off occurrences, just as the code here seems to have been (because it's been working fine).....