12.value

Hello everybody. I need to display the result in cell (17, lc + 1) with only one decimal, but the following instructions don't work (the value remains with 9 decimals). Sheet1.Cells(17, lc + 1) = cell.Offset(0, 12).Value / cell.Offset(0, 8).Value Sheet1.Cells(17, lc +...

Hi all I have workbook with 4 sheets("datanew", "dataold","higher", "lower"), now I want to find higher/lower value then copy to sheets("higher/lower") with conditions that: With sheets("datanew") lastrow = .Cells(Rows.Count, 12).End(xlUp).Row lastcolumn = .Cells(1...

I am trying to create coding that will loop through column L (12) and if the cell contains the specific text or value then enter "Previous" or "Current" in adjacent cell in column M (13): "Error" = Current "[Rr]etro = Previous > 201814 = Current all other cells = Previous Dim f As Long ' for...

Hi all I have been having issues with my match function if there isnt a match found. I had initially had worksheetfunction.match but read that i need to change to application.match but im still getting a type mismatch error - where am i going wrong? MatchHeaders =...

Hi, the first IF works very well thanks to the contributors/helpers on this board. Question though, id like to delete a row if certain cells contain a certain color (RGB120,20,50). However not working well for me, any suggestions please? For i = LastRow To 2 Step -1 If Cells(i, 2).Value >...