values of an interval of cells HELP ME

[Guest]

hello,
in the first line of the code of under I have the necessity to take me the values of an interval of cells that goes from the A13 cell to the G14 cell!!! I have written pippo.Range("A13:G14").value but it is wrong!!!
one solution

THANKS A LO

If pippo.Range("A21").Value = ActiveWorkbook.Path And pippo.Range("A13:G14").Value >= "0" Then
MsgBox ("file valido")
Else
MsgBox ("file non valido"

 

[Dick Kusleika]

fernando

Perhaps

If pippo.Range("A21").Value = ActiveWorkbook.Path And _
Application.Sum(pippo.Range("A13:G14")) >= 0 Then

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

hello,
in the first line of the code of under I have the necessity to take me the

values of an interval of cells that goes from the A13 cell to the G14
cell!!! I have written pippo.Range("A13:G14").value but it is
wrong!!!

one solution?

THANKS A LOT

If pippo.Range("A21").Value = ActiveWorkbook.Path And

pippo.Range("A13:G14").Value >= "0" Then