Thread: refedit query
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default refedit query

I just hit F4 in a refedit box and it worked fine - did you try it?

xl97, SR2

--
Regards,
Tom Ogilvy


Terry wrote in message
...
How can I toggle between relative and absolute cell references using the

F4
key after having selected a cell reference from a refedit control ?

I am unable to find the event in Refedit that will allow me to
use the F4 key. Please see Excel's Goal Seek Set cell: refedit control

box,
where you can simply use the F4 key to toggle between all the absolute and
relative
cell references combinations. Any help you can provide will be very much
appreciated.

Rdgs,

Terry