Automate Excel

4 Responses

1. ross Says:
   February 21st, 2005 at 2:28 pm

   on thing that caught me out with arrays a while back was in vb6 you can use array1 = array2 to copy an array, but not in vb5. Depending on how big the array is i now code using a VB5 method, or use an if, if it’s a big array - the VB6 way is quicker.

   Also when working with the worksheet it’s worth baering in mind the SpecialCells method which can save time (http://j-walk.com/ss/excel/tips/tip07.htm)

2. Mark Says:
   February 21st, 2005 at 9:22 pm

   Thanks for the link.

   From the kb article, transpose an array was new to me.

3. ross Says:
   February 22nd, 2005 at 12:10 am

   Yeah, I only seen that a few weeks ago too( in Excel 2002 VBA), you can use it to fill a combo etc - thats the example given in the book. I think that’s what Bullen, et al. mean when they talk about VBA developers and Excel developers - theres no way would have sat down and thought, mumm, i could use the transpose wsk fuction here, but hey, you live and learn!

4. JEROME Says:
   November 1st, 2005 at 8:58 am

   How to convert a word to a number

Leave a Comment