Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
counting cells by format of cell in
Name: thomasofspain Date: February 6, 2004 at 08:27:43 Pacific OS: Windows 2000 CPU/Ram: P4/512K
Comment:
I need to count cells in an Excel spreadsheet (in a given column) by cell format. (i.e. by color). I believe this would be a variation of the counta(value1, value2) function; but so far have been unable to construct anything that works.
Summary: Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your willingness. ...
Summary: I'm not sure why your paste function would have pasted rows of data into single column. Never heard of that before. Are you sure that each row of data isn't really pasted into a single cell in Column ...
Summary: Hi there I'm having a bit of trouble with links between one Excel doc and another. They work perfectly as long as both docs are open, but if, for example document 2 (referred to by a main document, do...
