| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA macro to populate formula result in 'next blank cell'
In a business spreadsheet, every time a predetermined condition is met I need
to record information on a "running" record. Ie. When condition 'A' is met, copy data to; 'Sheet1!E {nextblank}. As there will be a few things I need to record, I would like it all on the same row. Each data point will go in a corresponding column. *Note; the remainder of the macro will be constructed using the macro recorder. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula result = 0, do not display-leave cell blank | Excel Worksheet Functions | |||
| Function to treat formula result as blank cell | Excel Worksheet Functions | |||
| How do I have the result of a formula display in a blank cell | Excel Programming | |||
| How to get Blank into a cell as a result of a formula | Excel Worksheet Functions | |||
| How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
