Related:
- Copying a value in a cell
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - 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