To copy & paste cell content to thousands of cells:
1. Select and copy cell A1.
2. Type a cell address in the Name box, for this example, type A5000.
3. Press Shift+Enter to select the cells from A1:A5000.
4. To paste, press Enter.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"hi,
i am having query,
i am working on vba excel programming,here in sheet only some cells are editable,if u press F2 function key content will get cleared ,how to avoid not clear content of cells"
"hi,
i am having query,
i am working on vba excel programming,here in sheet only some cells are editable,if u press F2 function key content will get cleared ,how to avoid not clear content of cells"