Convert String Array to Integer Array from a User Input?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Convert String Array to Integer Array from a User Input?

FAQ

Thread Tools

Display Modes

12-26-2012, 06:02 AM

tinfanide

Windows 7 64bit Convert String Array to Integer Array from a User Input?

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

Quote:

Originally Posted by macropod

Try:
Hint: Storing integers as longs makes for more efficient processing, so consider:
arr(a) = CLng(Split(vInput, ",")(a))

Yes, it works. And by the way, I worked it out much the way like you do here, creating a new Long array and loop through it with the old String array.
Thanks for your hint, not that I didn't really know what Long is.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array argument in macro command	Wries	Excel Programming	2	11-20-2012 01:08 AM
How to reserve an array in a public function?	tinfanide	Word VBA	2	02-27-2012 06:51 AM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array	KIM SOLIS	Excel	5	09-07-2011 07:43 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 AM.