Array copy

Y

yogeshmaney

Active Member
Joined
Feb 25, 2010
Messages
321
Hi,

Array values from one Data should get copied to another cell of which the cell value provided by user

e.g

Suppose Array has values { 1,2,5,}

In another cell suppose i give value 5
Then in the values of array should get copied from 5th column



regards,

---Yogi
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Maybe something like...
Code: 
a = Array(1, 2, 3, 4, 5)
   Sheets("Sheet13").Cells(1, "A").Resize(UBound(a) + 1, 1) = WorksheetFunction.Transpose
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Add new Row in ListObject Table with data from an Array
Replies
4
Views
138
Akuini
Akuini
H
  • Question
VBA Join arrays together
Replies
7
Views
265
henrik2h
H
J
  • Question
Repeat VBA for each column
Replies
3
Views
234
Alex Blakenburg
A
P
  • Question
How best to copy a hidden sheet with a multiple formulas to create a multiple new sheets
Replies
7
Views
271
PaulskinX1
P
N
  • Solved
For next loop with array and using a variable in range().select
Replies
5
Views
195
notmeiquit
N

Forum statistics

Threads
1,215,491
Messages
6,125,109
Members
449,205
Latest member
ralemanygarcia

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top