next

  1. ibmy

    Compare a cell value with all the following cell values

    BF1OfferLow21.3031.7041.6052.4060.9070.3080.8090.20Low100.20Low111.80121.40133.00141.00Low151.30161.10Low171.90181.70Low192.00202.10212.30221.70Low231.80Low241.90Low252.50F2:F24F2=IF(B2<=MIN(B3:B$25),"Low","") When there are no value lower than a cell value, assign ("Low"), else (""). The...
  2. C

    IF THEN NEXT macro over large range

    I need a macro to, IF i5=-99 THEN delete A5:C5, then it needs to move to cell i6 and perform the same check IF i6=-99 THEN delete A6:C6. Needs to keep repeating this line by line check until reaching i1057. I don't expect necessarily to see the cursor moving through the sheet, just to end up...
  3. Amenolakaky

    Print all contents related to cell value_ get the path then open folder and print all contents then next_VBA.

    Hello All, I have something will save my time but i cant write the code. I have a list of shipments numbers in excel sheet also i have a huge folder with subfolder and each subfolder names as the shipment number is the excel sheet. Every folder has a ""PDF OR JPG" files. the result will be I...
  4. A

    IF Condition with "For" and "Next" Statement

    Hello, I am little confused from my first days in VBA Programming and I don't know, how to continue with my exercise... My goal is to generate an XML file using VBA code that will consist of data that is contained in more than 3 Excel sheets(TcC, TcA, TcO). I managed to write simple lines, but...
  5. B

    For...Next Loop doesn't work in UserForm

    Hello, Can some help me why below Loop doesn't work ? Numbering of "Labels" in UserForm is the same like numbering of "S" varabiles. Dim m As Byte Dim S1 As String Dim S2 As String Dim S3 As String Dim S4 As String Dim S5 As String Dim S6 As String Dim S7 As String Dim S8 As String Dim S9 As...
  6. I

    VBA Search Loop If Empty Copy Paste Next Help!!

    I am in VBA H**L right now. Here is what I need the Search Loop to do. In Column A cell "A2" is a changing value depending on the person selected. This is basically a RecordId column. Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain...

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