Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placing an array on the active 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 | |||
Extracting the latest info from 1st sheet and placing into a 2nd s | Excel Worksheet Functions | |||
Difficulty placing active email / hyperlinks with normal text in c | Excel Discussion (Misc queries) | |||
placing a button directly in a sheet | Excel Discussion (Misc queries) | |||
Need help with a tricky problem of placing a number within an array... | Excel Worksheet Functions | |||
help with placing Logo on excel sheet | Excel Discussion (Misc queries) |