Related:
- Copying a value in a cell
- Protect pdf from copying - Guide
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- How to delete a cell in word - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Cell phone codes - Guide
1 response
Well try this
Sub test()
Sheet1.cells(x,y).copy
Sheet2.activate
Sheet2.cells(a,b).select
activesheet.paste
End sub
x, y and a, b are the cells positions, the will copy from sheet1 cells(x,y) to sheet 2 cells (a,b)
well you can use a text array with a particular delimeter
Exemple: cells(1,1) = "a | B |c | d |etx "
| is the delimeter, to recover the data seperately just split them into an array later
Sub test()
Sheet1.cells(x,y).copy
Sheet2.activate
Sheet2.cells(a,b).select
activesheet.paste
End sub
x, y and a, b are the cells positions, the will copy from sheet1 cells(x,y) to sheet 2 cells (a,b)
well you can use a text array with a particular delimeter
Exemple: cells(1,1) = "a | B |c | d |etx "
| is the delimeter, to recover the data seperately just split them into an array later
