View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] skynugget@gmail.com is offline
external usenet poster
 
Posts: 2
Default programaticly filling a cell with a formula

hello all...
i have sheet with 6 columns abcdef.
in colum f (row 2)i have the formula =A2&TEXT(B2,"mmm-yy") i use this
for a refrence in another sheet in the book.

im trying to auto fill cell F with the above formula in a given row
after a value in cell A of the same row is entered. Or i guess it would
be nice for som code to combine 2 cell values and place it in cell F.

can anyone nudge me in the propper direction?

thanks!