macro checking
I have a print macro set up to print an area in a spreadsheet, is it poss to
have it look at a cell and chech to see if that cell on the sheet is greater than £0 if its value is greater than £0 then print if not then dont print .. Thanks in advance for any ideas |
macro checking
As always, post YOUR code for comments
if range("a21")<1 then exit sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Stan Halls" wrote in message ... I have a print macro set up to print an area in a spreadsheet, is it poss to have it look at a cell and chech to see if that cell on the sheet is greater than £0 if its value is greater than £0 then print if not then dont print .. Thanks in advance for any ideas |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com