| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting a formula next to populated cells
Hi All
I am looking for the most efficient way (in code) to insert a formula in the cell next to one that is already populated. I. e. Cells a5-a14 have dates. I want to insert the same formula in cells b5-b14. the range in col A changes. I have looked at help for autofill, filldown etc but I not sure how to test for cell a(x) being greater than "". Any suggestions would be appreciated. Thanks BRC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Cells and Formula References | Excel Discussion (Misc queries) | |||
| Inserting Cells and Formula References | Excel Worksheet Functions | |||
| formula accross cells..when inserting a row.. | Excel Worksheet Functions | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
| Populated cells | Excel Programming | |||
Threaded Mode
