two easy questions take two

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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
Click to expand...
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
Click to expand...
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?
 
Back
Top