Syntax to refer to a range within an array

[MrTeeny]

I'm doing some things with arrays but stuck on the syntax using the format array(i, 4) can anyone tell me how I would refer to the range array(i,1) to array(i,5) , I'm just trying to set the values to nothing within that range but unsure of the syntax and don't want to set each one separately if needs be, array(i1)="" etc.

 

[JackDanIce]

Try:

Dim y as Long
For y = 1 to 5
  arr(i, y) = vbnullstring
Next y

 

[MrTeeny]

Thanks, I was hoping to avoid looping if possible and hoped they'd be simple syntax similar to setting a range on a sheet like

[COLOR=#303336][FONT=inherit]Range[/FONT][/COLOR][COLOR=#303336][FONT=inherit]([/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]"A1:B2"[/FONT][/COLOR][COLOR=#303336][FONT=inherit]).[/FONT][/COLOR][COLOR=#303336][FONT=inherit]Value [/FONT][/COLOR][COLOR=#303336][FONT=inherit]=[/FONT][/COLOR][COLOR=#303336][FONT=inherit] ""[/FONT][/COLOR]

But so far not been able to find anything so maybe looping is the only option

 

[JackDanIce]

You could use Application.Index (search VBA slicing arrays) but for 3 lines of code to clear array elements across 5 columns, why not stick with a loop? I do not believe there would be any noticeable speed loss/gain with a different approach in this case

 

[Peter_SSs]

You could use Application.Index (search VBA slicing arrays)

You can values out of an array like that but as far as I am aware you can't put them in using that sort of syntax.

 

[JackDanIce]

@Peter_SSs true, I've only ever used it to read out of an array; it was more to suggest "something" other than looping, though unfortunately not a workable suggestion!

Hence for 3 lines of code to write to part of array that doesn't seem big in size, I meant to show you probably do not need anything more complex or written differently