#excel vba

Option Explicit Private Sub cmdSave_Click() Dim LR As Integer, Master As Worksheets Set Master = ThisWorkbook.Worksheets("Master") LR = Master.Cells(Rows.Count, "A").End(xlUp).Row If LR = 2 And Cells(LR, "A").Value = "" Then LR = LR Else LR = LR + 1 End If Master.Cells(LR...

I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...

I am trying to write a VBA Macro to a assign Actions to be taken (Column L) and Status of the component (Column M) based on the value of Size1 (Column C), Size2(Column D), Lot No (Column E), Item category (Column H) and Delta (Column K). Criteria which I'm using is as follow: If Lot ≠ Lot No...

Hi all,I got the below two sheet with the table look like below, and I would like to compare two table column to column (with the same header), and return true if exactly the same( like the below example),and return false if anything not the same (even the sequence is not the same ). I am new to...