#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
---


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"