Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-19-2020, 07:33 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Dim statement for Split array Windows XP Dim statement for Split array Office 2007
Competent Performer
Dim statement for Split array
 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default Dim statement for Split array


I don't understand why this code works:
Code:
Dim BlueLite As String          'Light blue RBG values
BlueLite = "219,229,241"        '.
Dim RGBVals As Variant          'Array for indivicdual RGB values
RGBVals = Split(BlueLite, ",")  '.
But this code gets a runtime error '13' (Type mismatch):
Code:
Dim BlueLite As String          'Light blue RBG values
BlueLite = "219,229,241"        '.
Dim RGBVals() As Variant        'Array for indivicdual RGB values
RGBVals = Split(BlueLite, ",")  '.
Aren't the parens required when declaring an array?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Dim statement for Split array Mail Merge - split merged documents and rename each split document based on text in header FuriousD Word VBA 1 05-12-2019 04:06 AM
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
Split word file into several PDF using the bookmarks as split positions and name Fixxxer Word VBA 7 10-08-2018 01:10 AM
Split function in Excel (split the screen) Officer_Bierschnitt Excel 1 07-05-2017 07:02 AM
Dim statement for Split array Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft