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.