next

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

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

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

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

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