Posted to microsoft.public.excel.programming

dan

external usenet poster

Posts: 866

Redim preserve does not work for me

I am trying to understand hoe redim preserve works, but I keep getting run
time error 9

Any idea what is wrong with my redim preserve.
Thank you.
Dan

For example in the bellow:

Public MyReportArray() As Variant
Sub testpreserve()
ReDim MyReportArray(5, 5)
MyReportArray = Range("A5:E5")
ReDim Preserve MyReportArray(6, 6)
MyReportArray = Range("A6:F5")
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Redim Preserve question	Sam Kuo[_3_]	Excel Programming	11	June 3rd 08 06:38 AM
VBA: What does Redim Preserve do in term of memory	Charles	Excel Programming	5	January 11th 08 09:53 AM
redim preserve	[email protected][_2_]	Excel Programming	3	December 15th 05 01:40 PM
Redim Preserve doesn't work	Witek[_2_]	Excel Programming	3	November 1st 04 11:34 PM
ReDim, Preserve and Multidimensional arrays	Andy Westlake[_2_]	Excel Programming	3	October 19th 04 07:04 PM

All times are GMT +1. The time now is 03:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us