View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Find ROW(INDIRECT()) wo the column letters

=ROW(INDIRECT("$AP" & $AP$11))<ROW($AP$208)

"nastech" wrote:

hi, had it before, cannot remember setup for formula to indirect a reference
to a row, without having to enter a column, i.e.:

=ROW(INDIRECT($AP$11))<ROW($AP$208)

AP11 = AP208, answer = false (works),
but need to be able to just enter the row number in AP11. maybe did not
even use INDIRECT..