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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:20 AM.