How to use an Array
I was wondering if anyone knew how i would use an array for this code.
The array would hold the strings ( "Status",.....)
The "C" representing columns 1 To 19
Idealy i would use one line to say for cells 1 to C, Execute the array.
Please Login or Register to view this content.
Somehting like this would be my guess.Please Login or Register to view this content.
Does anyone know the solution.
Thanx George
Perhaps you mean something along the lines of:
I would happily concede I'm most certainly not the best when it comes to working with Array's so someone else is likely to come up with a better approach than the above.Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That is great it works so long as i add an End to the last string which means it stops 1 before the end.
Maybe it starts at 0 apposed to 1Please Login or Register to view this content.
George
Yes, my bad, I did say I wasn't very good... you can use Option Base to force to start at 1 but instead of having End in your array use the original but with:
Please Login or Register to view this content.
Yeah that works fine now, I have only done this a few months so am probably pritty bad.
Thanx for the help
George
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks