adapt

Hi! I would like some help in order to change the range of action of a paste picture macro I would like to paste photo in range: - L17:U17 based on the value from L3:U3 - L40:U40 based on the value from L27:U27 - L63:U63 based on the value from L50:U50 - L86:U86 based on the value from L73:U73...

Hello, small problem: Right(elem.innerText, Len(elem.innerText) - InStrRev(elem.innerText, " / ")) This successfully pulls right of the "/". How would I adapt to include the "/" as well? Thanks.

Hello this code executes and does what I want to if there is text in the cell. It is still doing it if the cell is empty and there is a formula in there. Any ideas how to adapt it so that is ONLY executes when the cell is empty? If Not IsEmpty(Cells(ToRow, "E")) Then Thanks.

Hi I am using the following formula but would like to adapt and add to this. =IF(D3="","",IF(D3<8,100*D3,D3*150)) Where D3*150 is there a way to add in to only do this if 2 parameters are met. D3 higher than 8 and N2 40% and above, if bothe these parameters are met the D3*150. Thank you in...

Hi All, I have the below formula but I want it to return it as a hyperlink as it looks up email addresses, can any one show me how to adapt. =IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1))) Much appreciated...

I found the right formula I need on a site (that didn't explain it :crash:). Between this and other examples, I can't piece enough together to wrap my head around it. Two hours of googling and I'm done! This gives me the first Monday (obviously you probably already know that) and I'm wanting...

Hi all I have a loop amongst other things evaluates the following formula: prodcount = WorksheetFunction.CountIf(Range("CATGRPS"), Range("Cat_List_Unique").Cells(i + 1, 1)) Obviously when it loops back onto the next "i" then prodcount resets, How can i adapt it so where "i" is 1 i would...

Hi ! I have a data table like this : I need a formula to analyze if there are overlaps in the times by employee. I tried to use this formula : SUMPRODUCT(--((A1+C1<=$A$1:$A$15+$B$1:$B$15)+(A1+B1>=$A$1:$A$15+$C$1:$C$15)=0))<>1 But i couldn't adapt it to my needs. Thanks !!!

Following from this: https://www.mrexcel.com/forum/excel-questions/1045185-class-instead-array.html how would I adapt it if my code were: Do Until DataArray(j, 1) <> DataArray(j + 1, 1) ie the suggestion was: If myArray(i).Name <> myArray(i - 1).Name Then but my condition now...

Hello, This code removes the "/" from all cells in a column, how would I adapt to remove numbers please? Sheets("Sheet3").Columns("B:B").Replace What:="/", Replacement:="", LookAt:=xlPart

Hello! I'm hoping someone can help me with my current problem. I have thousands of cells that look like this: <tbody> <a *******="viewer.setParameter('SceneUrl', 'units/models/nomodel.stl');viewer.init(); viewer.update();" >Unit-Model-Here</a> </tbody> What I'd like to do is replace...

I want to put this code Rows("2:" & Range([A1], ActiveSheet.UsedRange).Rows.Count - 2).Copy in workbook1, workbook1 will open several workbooks (six) with vba. How can i adapt that code to select the range from the other workbooks and past on workbook1.sheet(named with the name of the files...