Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste using vb code
Please help me!!!
How do I paste, using vb code, a cells formula to the next empty cell in the same column? Thank you. -- ASU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy and paste using vb code
Dim myCell as range
dim DestCell as range set mycell = range("somecellthatyouwanttocopy") with worksheets("sheet9999") set destcell = .cells(.rows.count,"A").end(xlup).offset(1,0) end with mycell.copy destcell.pastespecial paste:=xlpasteformulas ===== Something like this actually pastes to the cell under the last used cell in the column. ASU wrote: Please help me!!! How do I paste, using vb code, a cells formula to the next empty cell in the same column? Thank you. -- ASU -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste formula using vb code | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
CheckBox Code to copy & paste range | Excel Discussion (Misc queries) | |||
copy and paste code problem | Excel Worksheet Functions | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) |