Placing an array on the active sheet

M

M R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top