1.
Sub test()
Dim arr() As Variant

arr = Range("a1:B10")
End Sub

2.
One cool thing about Excel is the macro recorder. Set that recording while
you perform the task manually. Once complete, stop the macro recorder and
take a look at what code it produced.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"brianelson" wrote in message
...
Sorry about that hit the enter button to fast.
Question one.
I have been trying to populate an array using the range method. Is that
only good for Values?? Will it work with strings?

Question Two.
I am trying to save/Export an Excel workbook to HTML but I want to have
it look like the web page preview (Office 2002). And I would like to do it
programmatically. Does anybody have a good code for this?

Thanks for any help