View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BRC BRC is offline
external usenet poster
 
Posts: 10
Default inserting a formula next to populated cells

Hi All
I am looking for the most efficient way (in code) to insert a formula
in the cell next to one that is already populated. I. e. Cells a5-a14
have dates. I want to insert the same formula in cells b5-b14.
the range in col A changes. I have looked at help for autofill,
filldown etc but I not sure how to test for cell a(x) being greater
than "". Any suggestions would be appreciated.
Thanks BRC