, January 05, 2012 9:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Test XL 2007 code on XL 2010
Hi Asa,
Thanks for testing the code. I always use arrays. Application.counta and
index would work on arrays just like worksheet function works in ranges.
Anyway I
@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Friday, January 06, 2012 2:56 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Test XL 2007 code on XL 2010
Hi Kris,
Works fine!
I think .Index worked ok on the array, and a quick test with .Count seemed
to work. I wonder
Hi Asa,
Thanks.
Cheers
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2)
Hi Asa,
Thanks for testing the code. I always use arrays. Application.counta and
index would work on arrays just like worksheet function works in ranges.
Anyway I converted those variant array into a range.
Can you please test this one for me ?
Sub kTest_v2()
Dim ka As Range, k(), i