failing

I feel this should be a very easy solution, but I am finding myself struggling. For p = 70 To 73 If tpgo = "<" Then pdd = format(ws_sbase.Cells(p, 2), "h:mm am/pm") If pdd >...

Good morning, I am trying to populate cells on a timetable document based on selections in two cells with data validation options and date/lengh and date/duration of project Can any one help? Trying and failing with conditional formatting

I have 40 queries. When I "Refresh All" I often encounter "the web.page function didn't finish within timeout of 100 seconds." I find, once it craps out, it cannot recover and waiting 100 seconds is too long. Each query normally takes 2-3 seconds, so I can tell quickly that it's failing. Is...

I have the following two IF statements and want to combine them into one. Both work. There are in different columns. Tried but sadly failing. Any help would be welcome. IF(B1="A",IF(H1< j1,"w",if(h1>J1,"L",IF(H1=J1,"D"))),"") IF(B1="H",IF(H1>J1,"W",IF(H1< j1,"l",if(h1=j1,"d"))),"")

Hi, i'm trying to apply =vlookup for the spreadsheet attached to look for portuguese translations into sheet1 ("original ptbr") and retrieve them into sheet2 ("match translation") but it is failing for some random values and i don't know why since the words and the translations are there. Here...

Range("K4:K107").Formula = "=PROPER(MID(E4,FIND("(",E4,1)+1,LEN(E4)-FIND("(",E4,1)-1))" I am getting error , 'expected end statement' , it is working okay in the cell , Through , it is failing Please help me

I was using the statement Sheets("GEN").Shapes("Rounded Rectangle 5").TextFrame.Characters.Text = "NOLOG" to change the text of a Rounded Rectangle on a worksheet. After coding, I was able to click the rectangle and cycle through various values (it toggles from NOLOG to TERSE to FULL and...