1. The current Sequential index fill takes lot of time. Pl introduce a simple Sl No. auto fill as we do through macros. The system can work  in such a way ithat it will accept the value of start sl no and end slno through msgBox and start from the location where the cursor is placed. 
2. Pl provide a valdiation for coulmn rage ( say column A, column B,  etc) to check whether the contents are ISTEXT,ISNUMBER if not highlight the invalid cells. It can be a select and validate those rows/columns on the lines above. 
There are no replies made for this post yet.