Hi,
Am alternating a workbook made by a colleague who, since then, has left the company.
Would like to make a PDF to email from a certain sheet.
This works fine, however, now I want to make it so that the pdf only shows a set range of cells.
Cell Range to be C1:K66
Attached you can find the VBA worksheet as it is now
, note that following lines were included by myself ( ' DIM rng as range '; ' Set rng = sheets("shoretank").range("C1:K66") ). I believe that these are not in the right position as my PDF still shows all cells in the sheets wich are not hidden.
Bookmarks