I am having a code for convert range to PDF when my condition is meet.
- If Cells(r, "C").Value = "LW300FV(ARAI)" And Cells(r, "S").Value >= 400 And Cells(r, "S").Value <= 500 Then
- Worksheets(mySheet).Range("B939:F980").ExportAsFixedFormat _
- Type:=xlTypePDF, _
- FileName:=FileFullPath, _
- Quality:=xlQualityStandard, _
- IncludeDocProperties:=True, _
- IgnorePrintAreas:=False, _
This is working properly.
But i want to include the range of Worksheets(mySheet).Range("B2:F24") along with the above code.
I don't know how to do this.
Can any one help me to solve this issue