View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marijan glavač marijan glavač is offline
external usenet poster
 
Posts: 3
Default Problem with Format statement

I am using in my code :

Public Sub PopuniGlavnuFormu()
lblOpis = Worksheets("Podaci").Cells(TrazeniRed, 3)
lblArtiklBroj = Worksheets("Podaci").Cells(TrazeniRed, 6)
lblSifraArtikla = Worksheets("Podaci").Cells(TrazeniRed, 7)
lblPopust = Format(Worksheets("Podaci").Cells(TrazeniRed, 13),
"0.00%")
lblCarina = Format(Worksheets("Podaci").Cells(TrazeniRed, 14),
"0.00%")
lblCijenaDobavljaca =
Format(Worksheets("Podaci").Cells(TrazeniRed, 12), "##0.00¤")
lblCijenaFcoZagreb = Format(Worksheets("Podaci").Cells(TrazeniRed,
15), "##0.00¤")
lblRokIsporuke = Worksheets("Podaci").Cells(TrazeniRed, 16)
lblIzvorPodataka = Worksheets("Podaci").Cells(TrazeniRed, 17)
lblStandard = Worksheets("Podaci").Cells(TrazeniRed, 10)
End Sub

and i got message :
Compile error : Can't find project or library

in the line lblPopust


Please help.