| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying Formulas to a Range in a Worksheet
Please can you help with the following problem:
I would like to apply formulas in say Row 5, to the following cells: F5, H5, J5, K5, O5, P5, T5, U5, Y5, Z5. These formulas are the copied from Row 5 to Row 10,000. The problem is, if I make a mistake in inputting data and I then need to clear the contents of a cell or an entire row, the formulas are lost in that row. How can I ensure that the formulas are not lost and still able to input data in the cleared cells. Mnay thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| applying formulas for all sheets selected | Excel Worksheet Functions | |||
| Applying formulas to filtered data | Excel Discussion (Misc queries) | |||
| Applying range names to existing formulas in separate worksheets | Excel Discussion (Misc queries) | |||
| Applying Formulas to Visible Cells Only | Excel Discussion (Misc queries) | |||
| Applying Offset to Range in VBA | Excel Worksheet Functions | |||
Threaded Mode
