The code below works great if I am on Sheet1, but what if Range("H3").Value is on Sheet2 and I am still on another sheet? Reason is because i want to save as CSV and that will delete Sheet2
Can't seem to get the syntax right
Can't seem to get the syntax right
Code:
Worksheets("Sheet1").Activate
ActiveWorkbook.SaveAs Filename:=pathbell & "CountSheet" & Range("H3").Value & "_Installer" & "_07032019" & ".xlsx", FileFormat:=51