View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carole O Carole O is offline
external usenet poster
 
Posts: 69
Default Range formula - urgent!

Excel 2003, SR 1

In a previous post, I asked about do loops, and the reply was to use range
instead - i.e.
Range(Range("J3"), Cells(Cells(Rows.Count, 1).End(xlUp).Row,
11)).Formula = _
"=IF(B3=""Employee:"",F3,"""")"

I thought I had it working, but something changed. The J column has numbers
in it until the data in the rows end. The problem seems to be that the
formula doesn't get placed in the K column (11).

This is a learning process for me, I'm not quite understanding this, just
doing what I'm told!

TIA,
Carole