Union

[Digitborn.com]

Why this is not working?

With ws
        Union(.Cells(lRow, 2).Value, .Cells(lRow, 3).Value, .Cells(lRow, 4).Value, .Cells(lRow, 5).Value, .Cells(lRow, 11).Value, .Cells(lRow, 12).Value, .Cells(lRow, 13).Value, .Cells(lRow, 14).Value, .Cells(lRow, 15).Value) = ""
   End With

Object required? Is there any other way to write it except:

With ws
        .Cells(lRow, 2).Value = ""
        .Cells(lRow, 3).Value = ""
        .Cells(lRow, 4).Value = ""
        .Cells(lRow, 5).Value = ""
        .Cells(lRow, 11).Value = ""
        .Cells(lRow, 12).Value = ""
        .Cells(lRow, 13).Value = ""
        .Cells(lRow, 14).Value = ""
        .Cells(lRow, 15).Value = ""
   End With

 

[Jonmo1]

How about

myarray = array(2,3,4,5,11,12,13,14,15)
for i = 0 to worksheetfunction.counta(myarray) - 1
      ws.Cells(lRow, myarray(i)).Value = ""
Next i

 

[Norie]

Why are you using Value for all the ranges within the Union?

With ws
    Union(.Cells(lrow,2).Resize(,4), .Cells(lrow,11).Resize(,5))=""
End With

jonmo

You should take a look at LBound and UBound when working with arrays in VBA.

 

[Jonmo1]

You should take a look at LBound and UBound when working with arrays in VBA.

I know, I'm still learning. I see Lbound and Ubound used alot on this forum, but have no idea what they do. I guess that's what I get for self teaching....LOL. Going to look into it though, thanks.

 

[Digitborn.com]

thanks norie, i see now that i don't need values..