Consulting

Results 1 to 4 of 4

Thread: Remove asterisk symbol

  1. 04-28-2005, 12:38 AM #1
    ilyaskazi
    ilyaskazi is offline
    VBAX Tutor ilyaskazi's Avatar
    Joined
    Mar 2005
    Posts
    202
    Location

    Arrow Remove asterisk symbol

    i want to remove asterisk symbol from the selected range of cells through vba.
    Reply With Quote Reply With Quote
  2. 04-28-2005, 01:21 AM #2
    Killian
    Killian is offline
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    I this to clear a cell that has an asterisk or remove the asterisk from the text/value in a cell?
    K :-)
    Reply With Quote Reply With Quote
  3. 04-28-2005, 04:45 AM #3
    Andy Pope
    Andy Pope is offline
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    Hi,

    Something like this maybe,

    Range("A1:A10").Replace "~*",""
    Cheers
    Andy
    Reply With Quote Reply With Quote
  4. 04-28-2005, 05:21 AM #4
    ilyaskazi
    ilyaskazi is offline
    VBAX Tutor ilyaskazi's Avatar
    Joined
    Mar 2005
    Posts
    202
    Location
    ITS PERFECT ANDY, THANK U......
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules