View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default IFstatement OR VBA

One other important thing, as expressed in my response to your other thread
....

Do remember to press CTRL+SHIFT+ENTER each time that you edit the top cell
array formula/before recopying down the col. Confirm it's correctly
array-entered by looking at the formula bar. You should see curly braces { }
wrapped around the formula by Excel. If you see no curlies, you gotta re-do
the array-entering again (click inside the formula bar, re-press
CTRL+SHIFT+ENTER).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---