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
- Excel multiple lines in one cell - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - 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
