| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
I am writing a macros program and am having trouble with a formula.
If I have a set of values in column A and would like to use those values in column B with a formula, is there a command that will fill column B with that formula? The number of data points I use is always different so I can not tell excel to fill column B up to row 60 because it is not always 60 points. I've tried this with no success..... Range(ActiveCell.End(x2Down)).Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
| macros on one page | Excel Discussion (Misc queries) | |||
| Enabling macros | Excel Discussion (Misc queries) | |||
| Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
| The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Threaded Mode
