macro checking

  • Thread starter Thread starter Stan Halls
  • Start date Start date
S

Stan Halls

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
 
As always, post YOUR code for comments

if range("a21")<1 then exit sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Set non-continuous PrintArea via Function / Name 0
Conditional auto printing in excell? 1
if every 3rd cell is > 0 8
Hide columns based on row values 2
Excel Formula or equation 3
Nested formular to give a word answer based on 2 cells 4
Increment by 18 1

Back
Top