PDA

View Full Version : [SOLVED] Remove asterisk symbol



ilyaskazi
04-28-2005, 12:38 AM
i want to remove asterisk symbol from the selected range of cells through vba.

Killian
04-28-2005, 01:21 AM
I this to clear a cell that has an asterisk or remove the asterisk from the text/value in a cell?

Andy Pope
04-28-2005, 04:45 AM
Hi,

Something like this maybe,


Range("A1:A10").Replace "~*",""

ilyaskazi
04-28-2005, 05:21 AM
ITS PERFECT ANDY, THANK U......:thumb