The Correct Syntax For Using Variables With Square Bracket Arrays

Hi

I need the correct syntax for using variables with square brackets.

[a11:ab11] = var

Works fine but when i add a variable it gives errors ie. [cx1 & ":" & cx2] = var

Please dont give an answer using range & .value, it has to be square brackets, as im trying to figure out how to use it.

Thanks & much appreciated

xladept

cx1 = "a16"
cx2 = "ai16"

Dim cx1 As String
Dim cx2 As String

Square bracket notation cannot use anything within it from the VBA world... it can only use Excel worksheet functions, references, etc. However, you can use Defined Names in the square brackets which can be set by VBA code. Not sure how efficient that would be, but it would work. For example, I am thinking something like this...

Please Login or Register  to view this content.

Originally Posted by Genus Max

[a11:ab11] = var

Works fine but when i add a variable it gives errors ie. [cx1 & ":" & cx2] = var

Shortcut notation of Evaluate method doesn't accept variable, so

Please Login or Register  to view this content.