12.value

  1. Nelson78

    VBA: result with only one decimal

    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 +...
  2. S

    Help to find higher and lower value theen copy to another sheet

    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...
  3. S

    IF....., If....., If.......else VBA

    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...
  4. M

    Match VBa error

    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 =...
  5. J

    VBA Cells and if

    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 >...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top