15.value

  1. C

    Within an IF statement, populate an array with values

    Hi, I've got a very basic if statement in VBA that color codes cells and writes text in an adjacent cell when conditions are met. The code is as follows and works exactly as I need: If Cells(rowCount, 15).Value = Cells(rowCount - 1, 15).Value And Cells(rowCount, 16).Value <> Cells(rowCount...
  2. H

    Change/Amend VBA Code To Run Fast

    Hello Friends, I have a set of data which contains shipment records. I have to hide the rows where Column O shows the status of the Shipment. I am using the below mentioned code to hide rows based on Column O Private Sub CommandButton1_Click() For a = 3 To 500 If Worksheets("RO").Cells(a...
  3. H

    Add 7 Rows and Three Columns from Sheet Values to Listbox

    Hello, I have a Listbox which in the Properties window I have Set ColumnCount to 3; ColumnHeads to 0; and ColumnWidth to 100 pt; 100 pt; 100 pt. I want to populate the Listbox with Sheet3 Values from Cells(6, 14)-Cells(11, 14) to Listbox Column 0 and for Listbox Column 1 and 2 from two...
  4. 3

    If Else

    Hi, I have the following code. I think I have the syntax correct but somehow I got error message: Compile error: Else without If. Not sure why. Wonder if someone could help point out the problem? finalRow = sht.Cells(sht.Rows.Count, "a").End(xlUp).Row finalRow_minMax =...

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