I have a vba issue. I have a sheet that has several Hidden columns and Rows. How do I set the print area so that it always sets print area from cell F1 down to the visible rows? For example:
if rows (3-25) is visible, the print area is set to whatever that’s visible in range F1: K25
If row (30 – 52 ) is visible then the print area is set whatever that’s visible in range F1: K52
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…