7/1/2010How to use Proper Case Function in Excel Macro VBA

In this example I will tell you how you can use Proper Case Function in Excel Macro VBA. Application.Proper(Cells(r, 1)). [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 7/1/2010 at 11:32 AM
Tags: , , ,
Categories: VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed

6/9/2010Change date format to australian data format with excel macro VBA.

In this example I will tell you how you can change the date format to Australian data format (DD-MMM-YYY) with excel macro VBA. [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 6/9/2010 at 12:14 PM
Tags: , ,
Categories: Software Testing | VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed

5/25/2010How to extract the first 100 characters from a excel cell using vba

Say Call A1 has the value In this example I will tell you how you can extract the first 100 characters from a excel cell using vba In Cell B1 write the function =MID(A1,1,100). [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 5/25/2010 at 5:38 PM
Tags: , , ,
Categories: Software Testing | VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed