| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking macro | Excel Discussion (Misc queries) | |||
| Macro for checking duplicate entries | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Checking and IF ? | Excel Worksheet Functions | |||
| Macro for Looping for Criteria Checking | Excel Discussion (Misc queries) | |||
Linear Mode
