Why not just hit the print icon on the toolbar or ribbon/QAT?

But you could record a macro when you print your worksheet, then assign this
macro to a button (from the Forms toolbar) placed on the worksheet.

wrote:

Yes got it working now thanks guys.
Is it possible to have a print button on the excel sheet, so i can print the
tariff details when the sales rep was entered them?

Richard

"Dave Peterson" wrote:

Try Biff's formula once more.

If it doesn't work, post the version of the formula you're using.

And check to see that you don't have any N/A errors in column R of Tarrif info.


wrote:

Hi
No its making my formulae that was working display #n/a.
Richard

"T. Valko" wrote:

Try it like this:

=IF(ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)),"",VLOOKUP(J4,'Tariff
Info'!$Q$3:$S$17,2,0))


--
Biff
Microsoft Excel MVP


"
m wrote in message
...
Hi
It said " you have entered to many arguments for this function" at the ""
point. I could email it to you to see?
Thanks Richard

"Sheeloo" wrote:

Try
=ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff
Info'!$Q$3:$S$17,2,FALSE))

" wrote:

I am having problem trying to get rid of #n/a error when i don't enter
a
value.
Anyone that can help, i would appreachate it.
here is the cells:
50mb £5.00 £5.01
100mb £10.00 £10.01
250mb £25.00 £25.01
#N/A #N/A
#N/A #N/A
#N/A #N/A
And formulae i am using
=VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE).


Also if anyone know how to add a button to finish processing the deal,
and
print to a templete that would be brill...

Richard





--

Dave Peterson


--

Dave Peterson