Thread: use macro to copy formula with value and not formula without value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ramzi ramzi is offline
external usenet poster
  
Posts: 24
Default use macro to copy formula with value and not formula without value
let say i have formula as below
A1 - 5 (=b1*c1)
A2 - 5 (=b2*c2)
A3 - 5 (=b3*b3)
A4 - 0 (=b4*b4) (can be zero or blank)

i wanted my mcro to copy from A1-A4 but only paste A1-A3, b'coz A4 is not
value to calculate.

thanks in advance
Reply With QuoteReply With Quote