Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Dynamic Range with Vlookup | Excel Discussion (Misc queries) | |||
URGENT - Help with choice of formula | Excel Worksheet Functions | |||
the best prediction formula?URgent! | Excel Worksheet Functions | |||
Urgent Formula Help | Excel Discussion (Misc queries) | |||
Urgent Formula! | Excel Discussion (Misc queries) |