Re: [belajar-excel] Tips Excel #8 - Mengubah Case di Excel

[Sofyan Efendi]

Yes, this error happen because the vbKatakana just applies to Japan system only.

  ----- Original Message ----- 
  From: sukarno 
  To: belajar-excel@yahoogroups.com 
  Sent: Friday, December 07, 2007 3:42 PM
  Subject: RE: [belajar-excel] Tips Excel #8 - Mengubah Case di Excel



  Aku coba merubah hiragana ke katakana, tapi kenapa error ya?



  Sub Ngubahkatakana()



  '(c) 2007, Opi, for milis belajar-excel



      Dim Sell As Range



      For Each Sell In 
ActiveWorkbook.ActiveSheet.Range(ActiveWindow.RangeSelection.Address)



          Sell.Value = StrConv(Sell.Value, vbKatakana)



      Next Sell



  End Sub





  Apanya yg salah ya..



  Makasih

  sukarno
  Recent Activity
    a..  9New Members
  Visit Your Group 
  Yahoo! Finance
  It's Now Personal

  Guides, news,

  advice & more.

  Featured Y! Groups
  and category pages.

  There is something

  for everyone.

  HDTV Support
  The official Samsung

  Y! Group for HDTVs

  and devices.
  .