View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mhd143 mhd143 is offline
external usenet poster
 
Posts: 7
Default Macro to change of a cell

Basically i've a range of cells in bit per million, whcih i need to convert
in %
E.g. 100(bits per million) * 100/1000000 = 1%

I need a for each statement too so it only changes cells with a value
greater than 0 please


"Norman Jones" wrote:

Hi MHD,

You should provide some additional detail as it is not immediately apparent
what you seek to do, or why a macro should be required.

Incidentally, if the earlier response was from you, a two minute gap between
inititial post and a 'bump' seems imordinately impatient.

---
Regards,
Norman



"mhd143" wrote in message
...
I need a macro to change a value of a cell from bits per million to %.