Nothing attached mate. dont forget to click upload
Simular issue i think. First of all, i think you should get rid of ' ChDir ("G:BSS BIPRResearch ShareHighways" & NameOfRoute)' as this shouldnt...
Yes mate, just do an if =IF(B2="","",B2&" "&TEXT(C2,"#%"))
Number 1 - The timer appears to pause if any button is pressed and you sit in the cell. I assume this is because the timer is running in the sheet? I ...
Link to the spready is not working (might be the file name), but is this what you are after? =B1&" "&TEXT(A1,"#%")
Sorry my post wasnt clear - I agree that repeatable actions should be automated, i just dont use arrays like you have suggested. It would be automa...
The first thing I would say is don’t use Merged cells - they are the antichrist of excel and will only cause problems later on, if not now. You can us...
I am not sure what part is question and what part is code - can you clarify your question?
One of the really annoying things that can take ages to sort out - the missing back slash at the end of the savepath savepath = "f:BSS BIPRResearc...
I think the pdf export part needs a defined path Worksheets("Successful Letter").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "SuccessfulLette...
1) The timer is not running if I press = sign, after pressing enter key it will aging running properly - Not sure what this means? Do you want the tim...
Depending on how complex the data is, =IF(COUNTIFS(C:C,C2)/COUNTIFS(B:B,B2)=1,TRUE,FALSE) might work? Purfleet
Hi Sholtan This question seems very similar to the last few that you have posted. Have you attempted to come up with a formula that can do what you ha...
The concept is simular with 2 workbooks and we can get VBA to open the workbooks if we know where they are located. I will update the code later an...
Not sure it will help much, but i would add rows at the row of the data, put in the formula and then freeze panes on the headers - see attached (sheet...