karthikthandapani
New Member
- Joined
- Apr 30, 2014
- Messages
- 14
Hi
Can you tell how to have the below static range to pick from a particular cell? For an example: you see Sheet1.Range("A1:C10") that actually a range to be copied & pasted into a PPT slide but can we able to change this to pick value from a particular cell ? I have the range to be copied from cell A2 in worksheet("Home")
Can you tell how to have the below static range to pick from a particular cell? For an example: you see Sheet1.Range("A1:C10") that actually a range to be copied & pasted into a PPT slide but can we able to change this to pick value from a particular cell ? I have the range to be copied from cell A2 in worksheet("Home")
Code:
'List of Excel Ranges to Copy from MyRangeArray = Array(Sheet1.Range("A1:C10"), Sheet4.Range("A1:C10"), _
Sheet3.Range("A1:C10"), Sheet2.Range("A1:C10"), Sheet5.Range("A1:C10"))