re-naming arrays in VBA?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
re-naming arrays in VBA?

FAQ

Thread Tools

Display Modes

03-15-2012, 08:34 AM

JDevsFan

Windows 7 64bit re-naming arrays in VBA?

Office 2010 64bit

Novice

Join Date: Mar 2012

Posts: 3

I believe I have acheived my result...

I defined the variable wrong. It needs defined as a variant (may be usefule to use a different defining value but right now this one works) then just set the variable equal to the array wanted.

Quote:

Dim arrayV As Variant

for j = 1 to 2
if j = 1 then
arrayV = dataL
else
arrayV = dataF
end If
...code
next j

simple change :-S

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Naming a cell then linking with a certain amount of charachters looses content.	shabbaranks	Excel	1	12-27-2011 01:06 AM
Auto file naming	Rong Peng	Word VBA	0	07-29-2011 07:37 AM
Auto-File Naming/ Default Directory Saves	sgill32	Word	2	11-06-2008 02:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 AM.