Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying an array variable to a sheet
Hi all,
I need some help with my first steps into Excel programming (Excel 2000, on windows XP) I have a vector defined as Dim zret() As Variant ' which later is redefined ReDim zret(n,1) ' n can get any value and is to be determined elsewhere ' after zret is filled with processed data I would like to place it on the active sheet. ' i do not want to use activesheet.range(" "), since it will require a predefined location and length. I have tried r=2 c=4 'ActiveSheet.Range(Cells(r ,c ), Cells(r + n - 1, c + 1)) = zret ' but I'm getting an error. Also, is there a way to name a range dynamically, with a number of columns and or rows determined in the subroutine? Thank you, MR, NYC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a variable as a reference to an array in INDEX | Excel Worksheet Functions | |||
Using COUNTA for a variable array | Excel Worksheet Functions | |||
Can I make array position A(12) into a variable A(12*n) ? | Excel Worksheet Functions | |||
use a variable array in a formula | Excel Discussion (Misc queries) | |||
variable in a link where the variable is the name of the sheet | Excel Worksheet Functions |