| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a formula to a range
Please help!
in column CY I have a list of names and there will never be an empty cell in the list but it will be of varying length from time to time. I want the VBA to copy the formula from cell CP1 and place it in Column CZ next to each entry in column CY - it must not extend beyond the length of the number of entries in column CY. I then want to check the results of the formula and wherever the letters "Ct" appear I want to change it to "J". my problem is determining how to make the formulas the same number as the number of entries in column CY. Can anyone help. I am using Excel 2007 and Windows 7 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula that contains a range of cell rows | Excel Discussion (Misc queries) | |||
| copying formula from one cell to a range | Excel Programming | |||
| Copying Formula into a Dynamic Range | Excel Programming | |||
| Problem copying formula to range of cells | Setting up and Configuration of Excel | |||
| Copying formula to the bottom of a range | Excel Programming | |||
Threaded Mode
