Related:
- Copying a value in a cell
- Protect pdf from copying - Guide
- How to delete a cell in word - Guide
- Excel add 1 if cell contains text ✓ - Excel Forum
- Conditional formatting if cell contains text ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
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
