Question

 How to disable cells in excel through VBA coding?

Answer I am going to assume that when you say "disable/enable" that you are referring to the Locking of cells, which can be done manually through the Formatting option. But to do that, you will also need... Read More »
http://answers.yahoo.com//question/index?qid=20090622052252AASQ51U

Top Q&A For: How to disable cells in excel through VBA coding

How to disable Columns or Rows in excel through VBA coding?

You do not need to use VBA to "disable/enable" cells, columns, rows, worksheets, etc... I am going to assume that when you say "disable/enable" that you are referring to the Locking of cells, whic... Read More »
http://answers.yahoo.com//question/index?qid=20090622085229AAvPY0P

Can Excel 2003 display the count of the cells and also sum of the cells together in status bar ?

From what I am aware of, not in the normal everyday way. From version 2003 or earlier, you may only see one of the aggregate values at a time in the Status Bar area, by right-clicking and choosing... Read More »
http://answers.yahoo.com//question/index?qid=20090704032914AAwNpmQ

Anybody tell me how to copy cells automatically in MS excel just by selecting cells by arrow key?

I am not sure why you would want to alter the typical functioning of the arrow keys, it would not be a wise decision. There are many shortcut key combinations of selecting cells within MS-Excel: ... Read More »
http://answers.yahoo.com//question/index?qid=20090610165301AAaKnMN

I want Excel to count how many cells contains "A" and how many "c" are under cells that contain "A"?

one solution could be this:The cells that contain a and c are in column Aexample of data:abcbadbcbcabbdcdaccdbthen in column B , cell b1 insert the formula:=IF(NOT(ISERROR(SEARCH("a";A1)));1;"")and... Read More »
http://answers.yahoo.com//question/index?qid=20120902234144AAnd4Ga


feedback
loading