Correct Macros in Excel Spreadsheet thats causing incorrect pages to export on print -- ON MAC 2011 -- 2
$2-8 USD / hour
Cancelled
Posted over 8 years ago
$2-8 USD / hour
I have an invoice / stock list generator that is coded with a macro that on Windows apparently is working fine and printing the exact of amount of pages from the Worksheet. It's printing 14 pages on Windows. 7 Pages from Sheet 1, and 7 Pages from Sheet 2-8.
BUT on my mac system, it's printing 7 Pages from SHEET 1, and then instead of printing Sheets 2-8 like it does on the PC, it's printing additional pages and cells from sheet 1. So page 8 will have a cell from Sheet 1 and thats it.
I've spent 2 days trying to fix this spreadsheet so it will print right... I don't want to invest a lot of more time trying things. I think the solution is to move SHeets 2-8 into Sheet 1. They have different amount of columns and thats why previous creators had or said they had trouble doing...
Sir/Madam,
Good day! I'm a degree holder related in Information Technology and I'm an expert in excel/spreadsheet with more than 10 years experienced. I have also tried working as virtual freelancer for 3 years. You will find me motivated and hardworking. Please contact me now. Thank you!
Preparation and Excel Reports Issuance of getting the best results in due time .
Elaboração e emissão de relatórios em Excel obtendo os melhores resultados em tempo hábil.
Hi,
I'm a final year Finance student based in the UK with 15 months experience in Excel/VBA report automation in Forex while doing a placement with a small financial firm (First Derivatives).
I have worked and solved several awkward bugs during my work so I should be able to help here and in particular issues with Print Areas. I have a feeling your issue could be down to the length of the Print Area formula. On windows I have had issues before with the 255 character limit and this could be smaller on Mac.
I have access to Excel 2016 on Mac and 2010/2013 on Windows so I can look at the bug from both systems.
My Skills
> Expert in Excel/VBA
> Able to use both Mac and Windows versions of Excel
Thanks,
Matthew