Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
how to do these things in Excel with and without VBA?
Hi all,
I am learning Excel/VBA via using it in real day-to-day work. Two questions: 1. How to multiple a whole range of cells by 2 all together and all at once? (element-wise). Of course, I am looking for more flexibility, such as apply a function to the whole region of cells. I understand that it could be done for rectangular shapes; is there a way to do this by first select a bunch of cells and label the cells as one single region(non-rectangular and non-regular shaped), and then apply function to this region as a whole? 2. This time I have a function in XLL (treated as black box here, it usually takes a column of values, or a row of values, treating these cells internally as a "vector" in C++). I have verified that the function works properly. But now, what if I want to select cells which are scattered around and not arranged in one row or one column ... It's like a multiple selection, and I don't have criteria for VSelect -- the cells should be selected by hand, no uniform criteria for any automatic selection... Please help me! Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste 2 different things from Excel to other programs | Excel Worksheet Functions | |||
Deleting things automatically in Excel | Excel Discussion (Misc queries) | |||
Strange things happening in Excel!!!!! | Excel Discussion (Misc queries) | |||
Can Excel do things lilke Quicken | Excel Discussion (Misc queries) | |||
Can Excel do things like Quicken | Excel Discussion (Misc queries) |