| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy paste cell with value using macro
hi there,
i want to copy paste those cell with value (number and character) and not formula. e.g. cell value formula A1 4 =d1*e1 A2 sell =f2 A3 6 =d3*e3 A4 (nothing) = f4 A5 (nothing) = d5*e5 so, the macro will copy paste at A1 to A3. and ignore A4 and A5. thanks for help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to copy and paste | Excel Discussion (Misc queries) | |||
| macro to copy and paste | Excel Discussion (Misc queries) | |||
| how to copy a cell in excell and paste in a txt file with macro | Excel Discussion (Misc queries) | |||
| Want to use a Macro to copy and paste cell *value* only | Excel Discussion (Misc queries) | |||
| Copy Paste macro | Excel Discussion (Misc queries) | |||
Linear Mode
